Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding items to a combo box on a user form | Excel Discussion (Misc queries) | |||
Adding Items To a combo Box | Excel Programming | |||
add items to combo box | Excel Programming | |||
Adding Items to a ListBox-Unique Items Only | Excel Programming | |||
Different colors for combo items | Excel Programming |