Can't you just set the listindex at the end of your population code.
Something like
Private Sub UserForm_Initialize()
Dim lCounter As Long
With cbInput
Application.EnableEvents = False
For lCounter = 1 To 10
.AddItem lCounter
Next lCounter
Application.EnableEvents = True
.ListIndex = 0
End With
End Sub
Robin Hammond
www.enhanceddatasystems.com
"DB" wrote in message
...
I have a combobox on a user form that is populated when the form opens.
The
listindex is not updated unless I "reselect" the same value from the
dropdown
menu. How can I have the listindex automatically update when the combobox
is
populated. This is on a pretty new version of Excel for Mac. I don't
have
this problem with the older version of Excel for Mac.
Thanks for any help
DB