Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a textbox in a UserForm where I add a string and when the entry is complete the After_Update event fires.
' In UserForm1 Private Sub TextBox1_AfterUpdate() MsgBox "After Update" ' Do stuff here End Sub What I'm trying to accomplish is to open a second UserForm so that I can search in a ListBox for the proper string to place in that original TextBox. ' From UserForm2 Private Sub CommandButton1_Click() Unload Me UserForm1.TextBox1 = Label1.Caption ' Populate TextBox1 with this result End Sub All works well with getting the TextBox populated with what I need to but I can't get the After_Update event to fire. Thanks in advance for your help. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
Event when a user form is loaded | Excel Programming | |||
keyboard event in user form | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |