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

apparently 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

Yup - 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...

Most 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.