ComboBox Default items Not Showing
 

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

ComboBox Default items Not Showing
 

Hi Shauna:

Your code works fine for me in Excel 2002.

Regards,

Vasant.

"Shauna Koppang" wrote in message
...
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

ComboBox Default items Not Showing
 

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.

--
Regards,
Tom Ogilvy

Vasant Nanavati wrote in message
...
Hi Shauna:

Your code works fine for me in Excel 2002.

Regards,

Vasant.

"Shauna Koppang" wrote in message
...
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