View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default 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.