andale, algo asi ocupo, pero lo que ocupo es que me cargue los combos desde que le doy click al boton en el worksheet de excel, mas no desde el form en si. La solución que encontre es la siguiente:
Código vb:
Ver originalPublic Sub LoadCombos(pcb As ComboBox)
With pcb
.Clear
.AddItem "Select..."
.AddItem "Yes"
.AddItem "No"
.Text = .List(0)
End With
End Sub
y mando llamar esa función en el initialize:
Código vb:
Ver originalPrivate Sub UserForm_Initialize()
LoadCombos answer1
answer1.Style = fmStyleDropDownList
LoadCombos answer2
answer2.Style = fmStyleDropDownList
LoadCombos answer3
answer3.Style = fmStyleDropDownList
LoadCombos answer4
answer4.Style = fmStyleDropDownList
LoadCombos answer5
answer5.Style = fmStyleDropDownList
LoadCombos answer6
answer6.Style = fmStyleDropDownList
LoadCombos answer7
answer7.Style = fmStyleDropDownList
LoadCombos answer8
answer8.Style = fmStyleDropDownList
answer9.Style = fmStyleDropDownList
End Sub