Full Version: Is there an event which is fired at a cell level which is trigge
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
GordMacDonald
Hi all,
Is there an event which is fired at a cell level which is triggered before the input id displayed?
I want to trap a condition and branch based on the input before the user sees what has been keyed in. any help would be appreciated.
Gord
GordMacDonald
FYI
pparently not - excel vba does not support a mouse_click event or other events that are triggered prior to content being added to the cell.
Gord
KingMartin
Hi Gord,
I am not sure if it helps, but have a look at Worksheet_SelectionChange() event.
It may be close to what you need...
Martin
GordMacDonald
Thanks Martin
up - I looked at it, but unfortunately it fires after the user input becomes visible.
Cheers
Gord
KingMartin
>It fires after you moved the selection to another cell before you enter anything in the cell...
ost probably I don't understand what you'd like to achieve sad.gif
Martin
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.