- Joined
- Sep 26, 2010
- Messages
- 2
- Reaction score
- 0
Hi All,
Excuse my ignorance, but I have just joined the forum today. Judging from previous answers this seems the place to be.
I'm trying to learn VBA all by myself but seem to be hitting a wall with what should be a very simple code.
I'll explain my problem as clearly and concisely as possible:
I am trying to set the value of a cell to "Y" depending on the value of another two cells.
For example, if Cell A < Cell B, then Cell C value should be "Y".
In the circumstances where the value of A changes, and is no longer less than Cell B, I want Cell C to
continue to show a "Y". That is, once the condition is triggered, and Cell C= "Y", I don't want the value to
be changed again.
I've tried using a Range value in an IF statement but to no avail. I think I'm missing something blatently
obvious, but I still can't fix it!!!!!!!!!!!!!!!!!!!
Many thanks to anyone who replies.
Cheers,
Herbie1809
Excuse my ignorance, but I have just joined the forum today. Judging from previous answers this seems the place to be.
I'm trying to learn VBA all by myself but seem to be hitting a wall with what should be a very simple code.
I'll explain my problem as clearly and concisely as possible:
I am trying to set the value of a cell to "Y" depending on the value of another two cells.
For example, if Cell A < Cell B, then Cell C value should be "Y".
In the circumstances where the value of A changes, and is no longer less than Cell B, I want Cell C to
continue to show a "Y". That is, once the condition is triggered, and Cell C= "Y", I don't want the value to
be changed again.
I've tried using a Range value in an IF statement but to no avail. I think I'm missing something blatently
obvious, but I still can't fix it!!!!!!!!!!!!!!!!!!!
Many thanks to anyone who replies.
Cheers,
Herbie1809