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
QUOTE
but unfortunately it fires after the user input becomes visible.

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.