auto updating cell values
 

Hey everyone,

Quick question. Can anyone help me with writing this macro? I have
spreadsheet, and in cell A2 is a value "100". In cell A3 is a list bo
with YES and NO replies. If someone selects No from the box, I need th
value of cell A2 left alone. But if someone selects YES from the list
I need the value to automatically update to 99 (A2.value - 1). An
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=26107