My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Is there an event which is fired at a cell level which is trigge
|
|
 Jan 22 2007, 01:43 PM
Post
#1
|
|
|
UtterAccess Addict Posts: 231 From: Canada  |
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 |
 |
 
|
|
Jan 22 2007, 03:20 PM
Post
#2
|
|
|
UtterAccess Addict Posts: 231 From: Canada |
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 |
|
|
|
|
Jan 22 2007, 03:39 PM
Post
#3
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
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 |
|
|
|
|
Jan 23 2007, 12:54 AM
Post
#4
|
|
|
UtterAccess Addict Posts: 231 From: Canada |
Thanks Martin
Yup - I looked at it, but unfortunately it fires after the user input becomes visible. Cheers Gord |
|
|
|
|
Jan 23 2007, 01:19 AM
Post
#5
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
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 (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif) Martin |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th June 2013 - 11:15 PM |