View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
damorrison damorrison is offline
external usenet poster
 
Posts: 91
Default Populate a combo box

I am using the add item way to populate a combobox in a userform

Private Sub Userform_Initialize()
With Me.ComboBox1
.AddItem "A"
.AddItem "B"
.AddItem "C"
..AddItem ""

End With
End Sub

How does one add an Item when the user types in a name that is not in
the list