combo box beginner question...
AddItem is correct, but not in the Change-event.
It seems to me you start with an empty combo, so it's value can never be
changed if it's empty.
In Visual Basic Editor, double click on ThisWorbook in your Project Explorer
on the left.
Then, copycat the following piece of code:
Private Sub Workbook_Open()
Sheets(1).ComboBox1.AddItem "A"
Sheets(1).ComboBox1.AddItem "B"
End Sub
"thomas" schreef in bericht
...
I've tried to find how to make choices in a combo box but had no luck.
This
is the code I wrote, but it doesn't show up in the combo box:
Private Sub Internet_Change()
With Internet
AddItem "A"
AddItem "B"
End With
End Sub
Why doesn't this show up when form is ran???
Thanks ahead of time,
Tom
|