View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default UserForm1.ComboBox1 to initialize

The initialize event occurs with the UserForm, not the ComboBox.

Private Sub UserForm_Initialize()
With Me.ComboBox1
.AddItem "item1"
.AddItem "item2"
End With
End Sub

The ComboBox should then display the two items as options in the drop down.

"Philosophaie" wrote in message
...
In "View Code" of Userform1 I can not get UserForm1.ComboBox1 to
initialize:
item1
item2
when I show the userform.

Private Sub CommandButton1_Click()
With UserForm1.ComboBox1
.AddItem "item1"
.AddItem "item2"
End With
.
Userform program
.