Select Multiple items from a Combobox

[jeh]

Hi again,

I have a Combobox on my sheet(control tool box) that has names in it. I want ot be able to select as many names as I want from this combobox, and copy/paste them to another sheet.

Any Ideas?

Thanks very much for your time,

Jim

 

[Joe Was]

You may want to change to "Check-Box's." JSW

 

[jeh]

Hi Joe,

I have 7820 names in this Combobox. I wish that were an option.

Thanks for your reply,

Jim

 

[Asala42]

Hey there,

I don't believe Combo-boxes have a multi-select property (from either the forms toolbar or the Control Toolbox). Can you get away with using a Listbox (from the Control Toolbox Toolbar) instead? The listbox will allow you to select multiple options.

 

[jeh]

Hi Asala42
I have a Combobox with (properties- liststyle-Option), but if that will not work, I don't see a problem with a listbox if this will help me with what I need.

Thanks for your reply,

Jim