Drop Down with multiple choices?

Is it possible to create (without too much difficulty) a drop down list that allows the user to select/check more than one selection? I have a form that I would like to allow the end user to simply select a pull down with several choices in which they can select more than just one item. I'm not that great with Excel, so if this is possible please tell me in newbie language if at all possible.

Out side of having 6 pull downs side by side to allow up to 6 different choices, or adding 6 check boxes,..there has to be a cleaner way. These options are not great due to the fact that I will need to have these options on 12 different rows throughout the form. A drop-down seems cleaner.

An ideas?

Thanks in advance!
Todd

Jason,

Thanks for the input, but I don't think that this is really what I'm after. How about a drop down that allows the user to use the CTRL key to choose more than 1? reason I say this is that the names on the drop down are long,...so ading a comma in a comb box would end up getting ugly quick if someone chose 4 items with long names....

td

Based on your request, you may be more interested in using a "List Box" instead of a "Combo Box" (a combo box allows one selection at a time, aka a 'drop-down list').

The List Box can also be "drop-down" in style, but you can set it to select more than one item by changing it's 'MultiSelect' property to '1-fmMultiSelectMulti' and setting the 'ListFillRange' property to the range of cells you want available in the list.

For example, if your list is in A1:A5, set the ListFillRange to: A1:A5

To add a List Box to your sheet, open the Control Toolbox toolbar (View - Toolbars - Control Toolbox). Exit design mode and your new list box should be active. Just hold down CTRL to click on multiple items in the list.

Todd,

Even with the sheet protected and the file saved, I can go back in and select items from the list box, and I can even bring up the Control Toolbox to edit the design and properties of the list box.

To make sure, when protecting the sheet, I selected every checkbox available so as to give myself very little control over the worksheets. I was still able to use and edit the list boxes I created. Not sure what you're doing that gives you any different results.

Just make sure in the List Box properties that Enabled is set to True. If this is set to False, the list box just sits there. (You can set the Locked property to False if you want to be able to edit its properties while the sheet is protected. Otherwise, leave it at True.)

--EDIT: Correction, I de-selected every checkbox in the sheet protection dialog, including the ability to select locked and unlocked cells. I could still select items in my list boxes.--

Worked great!!!!!!! Thanks! What I had to do was simply protect it, save it,...close the file,...reopen it and enable the Macros and it worked. Stupid me.

Thanks so much!!!!!

I think that is awesome. Now I'm left wondering if the same can be done with a combo box? I tried to have it where you can select more than one option from the list that appears at the bottom of the combo box when depressing the arrow, and the choices would all show up inside of the box. It wouldn't let me. I could only select the one option and that would appear in the box.

td

Unfortunately I'm not aware of the ability to get a combo box to act like a list box. Maybe there's a custom ActiveX control out there somewhere?

Using Jason's post above, you could - through code - have another cell store the value of a combo box, and each time you changed the selection in the box it would add to the end of the values in that cell. (Each time you select a new item in the combo box, the code would take the current string value of, say, cell H1, then append your most recent selection so it would read "Option 1, Option 2, Option 3, etc.")

Obviously if you have combo box options other than one or two-character codes, that cell could get unwieldy. Then you'd also have to consider how to remove either accidental or unnecessary entries into your calculated cell.