Deepak
Excel Ninja
Hi,
While doing some excelling i came to this question which had also puzzled me many times.
Can i have your valuable feedback on the same.
Why the multiple event [How may times tried to wrong entry in a DV cell before actual] is raised since the cell is not actually changed.
It is almost as if the event is raised on junk entry, but the DV alarm has precedence, the DV reverse the entry and another event is raised, and finally all events get processed.
Ref Q - http://stackoverflow.com/questions/36987845/data-validation-and-worksheet-change-event
While doing some excelling i came to this question which had also puzzled me many times.
Can i have your valuable feedback on the same.
Why the multiple event [How may times tried to wrong entry in a DV cell before actual] is raised since the cell is not actually changed.
It is almost as if the event is raised on junk entry, but the DV alarm has precedence, the DV reverse the entry and another event is raised, and finally all events get processed.
Ref Q - http://stackoverflow.com/questions/36987845/data-validation-and-worksheet-change-event