View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacy Erdelt[_2_] Jacy Erdelt[_2_] is offline
external usenet poster
 
Posts: 5
Default Add.item in combo box not working

I created the following code, so when the form pops up the combo box should
populate with those values, but it doesn't. When the form pops up there is
nothing listed in the box. The only way I have been able to get it to
populate is if a specify a cell range in the boxes properties, but not all of
the properties I want are listed consecutively (and I would like to keep it
that way, if possible). What am I doing wrong?

Private Sub frmEnterNewConsult_Initialize()
'Fill ComboBox
With cboStore
.AddItem "178"
.AddItem "203"
End With

cboStore.Value = ""

Store.SetFocus

End Sub

Your help is greatly appreciated!