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
___________

--
Message posted from http://www.ExcelForum.com