easy combo box issue
jasonsweeney < wrote:
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
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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.
|