I have combo box in a userform with the preference set as "Dropdown List". The list consist of "Select One", "Option 1", "Option 2". The "Select One" is automatically display when the userform appears. when I click the combo box, the list is display in the drop down view and "Select One" is highlighted in the combo box.
Is it possible to display the list without "Select One" being hightlighted in the combo box?
You probably wrote something like this:[VBA]Private Sub UserForm_Initialize()
With Me.ComboBox1
.AddItem "Select One"
.AddItem "Option 1"
.AddItem "Option 2"
.ListIndex = 0
End With
End Sub[/VBA]
And try this:[VBA]Private Sub UserForm_Initialize1()
With Me.ComboBox1
.AddItem "Option 1"
.AddItem "Option 2"
.Value = "Select One"
End With
End Sub[/VBA]