Thread: VBA Combo Box
View Single Post
  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Yep.

And I didn't notice your typo in the original post:

.AddItem = "Female"
should be:
.AddItem "Female"

(no equal sign)

Jeff wrote:

"Dave Peterson" wrote:

It is in a form

Private Sub UserForm_Initialize()
With ComboBox1
.RowSource = ""
.AddItem "Male"
.AddItem = "Female"
End With
End Sub

Gives an error. Is this what you meant by "Userform_Initialize" procedure


--

Dave Peterson