I was wondering, can you give a combobox a value i.e. Me.ComboBox1.ListIndex = 0 and not have the ComboBox change event fire unless the value gets changed?
Private Sub test()
Me.combobox1.RowSource = "ComboTypes"
Me.ComboBox1.ListIndex = 0
End Sub
Private Sub ComboBox1_Change()
'do stuff if value is changed
End Sub
Private Sub ComboBox2_Change()
'do more stuff
End Sub
I'm finding that since I'm giving a value to ComboBox1, the focus switches to ComboBox2 without user interaction. I would like ComboBox1 to have focus and wait till the user presses the enter button, or clicks combobox2 with the mouse (acknowledging that combobox1 has the correct default value). Is that possible?
Bookmarks