Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo box and first record
- Thread starter KatGraham
- Start date
Is the following bit of code what you are looking for. I think you need to use the ListIndex method.
Private Sub UserForm_Activate()
With ComboBox1
.AddItem "Item 1"
.AddItem "Item 2"
.AddItem "Item 3"
.AddItem "Item 4"
.ListIndex = 0
End With
End Sub
Private Sub UserForm_Activate()
With ComboBox1
.AddItem "Item 1"
.AddItem "Item 2"
.AddItem "Item 3"
.AddItem "Item 4"
.ListIndex = 0
End With
End Sub
- Status
Similar threads
- Locked
- Question