Hello all,

I am having a bit of a problem trying to figure out how to write thi
code.
Basically, I have in Cell A1 a value (ie 100) and cell A2 is a dro
down
validation box with 2 possible responses (YES & NO). What I need is
code,
that will automatically update the value of A1 if cell A2 is set t
YES.
It's a count of what is left.

ie. A1 = 100 and you select YES for A2, then A1 needs to update to 9

(A1.value - 1), but if A2 is NO, then no change is made to A1.

Any help provided will be greatly appreciated!!

Thoma

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=26123