Jan 22 2007, 01:43 PM
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.
Jan 22 2007, 03:20 PM
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.
Jan 22 2007, 03:39 PM
I am not sure if it helps, but have a look at Worksheet_SelectionChange() event.
It may be close to what you need...
Jan 23 2007, 12:54 AM
Yup - I looked at it, but unfortunately it fires after the user input becomes visible.
Jan 23 2007, 01:19 AM
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here