Hi
I have a drop down validation cell on an excel sheet and some code on the worksheet change event.
If the user selects from the drop down I want to check the new value and then be able to change it back to the previous value?
The target is the new value. How do I get the previous value of the cell?
Thanks
I have a drop down validation cell on an excel sheet and some code on the worksheet change event.
If the user selects from the drop down I want to check the new value and then be able to change it back to the previous value?
The target is the new value. How do I get the previous value of the cell?
Thanks