UserForm ComboBox Change Event Question

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?

Please Login or Register  to view this content.

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?

Thanks again JosephP for helping me out and quickly at that!!!

Have a nice day.