Adding items to a combo box
If you want multiple selections, then using a combobox would be the wrong
control. Use a listbox instead.
I would say don't use the Change event to populate the Combobox. If you
look at the events of the userform, there are the Initialize events and the
Activate event which might be a more useful place to populate the Combobox.
--
Regards,
Tom Ogilvy
"Phrank" wrote in message
...
Hello,
I've got a combo box on a form, and I'm trying to add items to it;
however, the items are not showing up - I believe I'm missing a step.
I've got the following in the code for the combo box right now:
Private Sub cbWhatToProcess_Change()
cbWhatToProcess.AddItem "Draft"
cbWhatToProcess.AddItem "Final"
cbWhatToProcess.AddItem "Other"
cbWhatToProcess.AddItem "Signature Pages"
cbWhatToProcess.AddItem "Regular PDF"
cbWhatToProcess.AddItem "Special PDF"
cbWhatToProcess.AddItem "Colored Graphs"
End Sub
I also want to be able to select multiple items from the list, so is
there anything special I need to do in order to do that? Thanks.
Frank
|