Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA help
In excel:
Inputs: C8-- button can change value to 1 or 0 C9-- =A3 (which can either be a 1 or 0) Output: C10-- =IF(C8=1,0,IF(C9=1,1,0)) Dilemma: When C10 is equal to 1, I want D10 to read "LATCHED". However, when C10 turns back into a 0 by changing the inputs, I want D10 to still read "LATCHED". I want to be able to do this without buttons, requiring the use of Worksheet_Change or something manner which I have no idea about. Thanks in advance! |