gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,341
- Office Version
- 365
- Platform
- Windows
Whats the difference between
AfterUpdate
BeforeUpdate
Change
Click
Enter....
In my combobox once the user scrolls and selects an item, I want the other TextBoxes on the form to automatically update. Right now they only update after the user tabs out of the combobox. Thanks
AfterUpdate
BeforeUpdate
Change
Click
Enter....
In my combobox once the user scrolls and selects an item, I want the other TextBoxes on the form to automatically update. Right now they only update after the user tabs out of the combobox. Thanks
Code:
Private Sub ComboBox1_AfterUpdate()
TextBox1 = Sheet10.Range("G18").Value
TextBox2 = Sheet10.Range("G20").Value
TextBox3 = Sheet10.Range("I22").Value
TextBox4 = Sheet10.Range("I24").Value
End Sub