"ComboBox1.ListIndex = 0" Doesn't seem to always work.

[JudgeMental]

Hi,

I have "ComboBox1" on a UserForm. In the Sub Form Initialize procedure, I
have "ComboBox1.ListIndex = 0" hoping to set the ComboBox to Index 0 every
time the Form is loaded. The problem is that maybe 50% of the time it loads
up with the last selection instead. Am I doing something wrong?

Thank you for your help!

 

[JLGWhiz]

If you are hiding your UserForm instead of unloading it, then the initialize
event won't fire when you show it again and your ComboBox will show the last
selected value. Since you didn't post all of your code, I can't tell you
much more.

 

[Jon Peltier]

If indeed the form was hidden, you could put the code into UserForm_Activate
to reset it when it is redisplayed.

- Jon