ComboBox Default items Not Showing

[Shauna Koppang]

I am a beginner at VB so please be patient.

I have the following code in my initialize statement:

'Sets ComboBox RowSource
ComboBox1.RowSource = "Names"
ComboBox2.RowSource = "Names"
ComboBox3.RowSource = "VendorCode"

'Sets default item from lists in ComboBoxes
UserForm1.ComboBox1.ListIndex = 0
UserForm1.ComboBox2.ListIndex = 0
UserForm1.ComboBox3.ListIndex = 0

For some reason only ComboBox 1 show default text
highlighted in blue as the default, where the others do
not. I have checked the Properties for all 3 and they are
set correctly and all items correctly show in the lists of
the combo boxes and can be selected or pick up from first
characters typed.

Any suggestions on how I can get the first item of my
lists to appear highlighted in ComboBox 2 and 3?

Thanks!
Shauna

 

[Vasant Nanavati]

Hi Shauna:

Your code works fine for me in Excel 2002.

Regards,

Vasant.

 

[Tom Ogilvy]

Wonder if there are any change events linking the comboboxes.

However, since this doesn't change, why not just make these settings in the
property box of each combobox in the VBE.

 

[Shauna Koppang]

HI Tom,

I did originally have them in the Properties but as I
could only seem to have 1 working I decided to try forcing
them through the Initialize statement instead.

What change events should I be looking for?

Any other suggestions? It should work!

Shauna