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

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

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

Thanks Martin

Yup - I looked at it, but unfortunately it fires after the user input becomes visible.

Cheers
Gord

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

Martin