way to run sub after user exits textbox
 

any idea how to run a piece of code once a user has exited a textbox?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=386376

way to run sub after user exits textbox
 

If on a userform, use the exit event. If your position is that that is
before the exit, then there is no event after the exit. There may be a
workaround, but that would require knowing what you want to do.

--
Regards,
Tom Ogilvy


"funkymonkUK"
wrote in message
...

any idea how to run a piece of code once a user has exited a textbox?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=386376

way to run sub after user exits textbox
 

Assuming it is a textbox from the Controls toolbox, right click and choose
View Code, then in the header section of the code pane write your code in the
LostFocus event procedure (e.g. Private Sub TextBox1_LostFocus())

If it is on a UserForm, same idea but it would go in TextBox1_Exit()


"funkymonkUK" wrote:


any idea how to run a piece of code once a user has exited a textbox?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=386376