way to run sub after user exits textbox

funkymonkUK · #1 07-12-2005, 05:17 AM

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

#2 07-12-2005, 09:06 AM

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" <funkymonkUK.1s1x2c_1121162725.2634@excelforum-nospam.com>
wrote in message
news:funkymonkUK.1s1x2c_1121162725.2634@excelforum-nospam.com...
>
> 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
>

#3 07-12-2005, 09:06 AM

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
>
>

Welcome to the Excel Forum

Forum Statistics