TextBox focus
Sheet1.TextBox1.Activate
--
Regards,
Tom Ogilvy
"René" wrote in message
...
Hi!
I'm validating a TextBox, if there is no data, then a MsgBox pop up
telling the user what they need to do.
What I would like to happen after they click the "OK" of the MsgBox is the
cursor be placed in the TextBox.
Here is part of my code:
If Sheet1.TextBox1.Value = "" Then
MsgBox "Please enter a name"
Sheet1.TextBox1.SetFocus
End If
Thanks in advance
|