easy combo box issue

  • Thread starter Thread starter jasonsweeney
  • Start date Start date
J

jasonsweeney

Problem With a combo box. For some reason, the combo box will no
populate until someone clicks onto the combobox and tries to ente
text. Then the proper list displays. If you just click on the comb
box, its empty.

Here is the code I used:
_____________
Private Sub defaultscorecombobox_Change()

Dim defaultlist As Variant
defaultlist = Worksheets("SPSOP").Range("Z2:Z11")
Mastercontrol.defaultscorecombobox.List = defaultlist


End Sub
___________
 
jasonsweeney said:
Problem With a combo box. For some reason, the combo box will not
populate until someone clicks onto the combobox and tries to enter
text. Then the proper list displays. If you just click on the combo
box, its empty.

Here is the code I used:
_____________
Private Sub defaultscorecombobox_Change()

Dim defaultlist As Variant
defaultlist = Worksheets("SPSOP").Range("Z2:Z11")
Mastercontrol.defaultscorecombobox.List = defaultlist


End Sub
Click to expand...

That's because you're using the change event to populate the combobox,
hence it is populated when someone enters text. You have to put this
piece of code in the Userform_Initialize event.

Regards,
 
Back
Top