View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default Manually Update Listindex

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