| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a procedure when exiting a a textbox within a userform
Hi,
I have a userform with a bunch of textboxes. Once someone types something into userform1.textbox1 and press the tab or select another textbox, I would like to run the code from a procedure. I know it is not textbox1_onclick but is there something similar to this? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run a procedure when exiting a a textbox within a userform
You can use the Exit event of the textbox:
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) ' your code here End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "borg" wrote in message ... Hi, I have a userform with a bunch of textboxes. Once someone types something into userform1.textbox1 and press the tab or select another textbox, I would like to run the code from a procedure. I know it is not textbox1_onclick but is there something similar to this? Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run a procedure when exiting a a textbox within a userform
Thank you so much!!!
"Chip Pearson" wrote: You can use the Exit event of the textbox: Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) ' your code here End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "borg" wrote in message ... Hi, I have a userform with a bunch of textboxes. Once someone types something into userform1.textbox1 and press the tab or select another textbox, I would like to run the code from a procedure. I know it is not textbox1_onclick but is there something similar to this? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question about exiting a procedure | Excel Programming | |||
| Exiting a procedure with a userform | Excel Programming | |||
| Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
| Userform maintaining items in list box after exiting Excel | Excel Programming | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Linear Mode
