Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I expose the TextBox BeforeUpdate event to my user class? | Excel Discussion (Misc queries) | |||
User Form in VB = TextBox | Excel Discussion (Misc queries) | |||
Textbox trouble on a user form | Excel Programming | |||
Format of a textbox on a user form controled by a spinner | Excel Programming | |||
User Form textbox formatting | Excel Programming |