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!

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.

"JudgeMental" wrote:

> 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!

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JLGWhiz" <(E-Mail Removed)> wrote in message
news:740361A4-E4AE-4E35-B925-(E-Mail Removed)...
> 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.
>
> "JudgeMental" wrote:
>
>> 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!