UserForm Combobox Change

[gheyman]

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

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

 

[mart37]

Use: ComboBox1_Change

 

[Fluff]

I tend to use the Click event