Hi,
Is there any way to modify the value of a cell in Beforecellupdate or aftercellupdate events. Or any similar events. when my user edit a cell and leaves it, I would like to catch a event where I can verify the value and change it if necessary. I know that e.Cancel helps to reject the newvalue. I am looking for a chance to change the value.
Thanks in Advance,
Reddy.
I would think BeforeCellUpdate would work. But I assume since you are asking the question that trying to change the value in this event is not allowed.
If that's the case, then maybe I recommend trying BeforeExitEditMode.