event which occurs when a TextBox receives focus
Where it the textbox. What type of control is it (Control toolbox Toolbar
or Drawing Toolbar)?
If on a worksheet and ActiveX/Control Toolbox Toolbar, then use the GotFocus
event.
--
Regards,
Tom Ogilvy
"Mikhail" wrote in message
...
When my text box receives focus, what event occurs?
I need this to be able to undo user's changes.
Dim OldValue as String
'when TextBox receives focus
OldValue = TextBox1.Text
'when user decides to discard changes
TextBox1.Text = OldValue
Thanks in advance,
Mike510
|