Better to use the Exit Event of the Textbox to check the entry. Then if it
is improper, the Event has a Cancel variable. If you set this to False, the
textbox won't be exited. It sounds like you are probably already using
this event to popup a msgbox, so just set the Cancel variable to true.
--
Regards,
Tom Ogilvy
"jgmiddel" wrote:
Hi, I would like to check (on Exit) a value entered in a textbox with a
certain cell. That's not the problem, but I would like to find a method
how
to move the cursor to the wrong entered value (so: back to that
textbox).
The error is given in a MsgBox.
Thanks in advance!
--
jgmiddel
------------------------------------------------------------------------
jgmiddel's Profile: http://www.excelforum.com/member.php...o&userid=32714
View this thread: http://www.excelforum.com/showthread...hreadid=527545