Forum Discussion
Making Multiple Selections From a Dropdown List
I'm going to assume this can be done because you guys are smart and will figure this out. I would like a dropdown list to appear for a column that has 6 choices. I want to be able to select more than 1 item using the ctrl button + mouse click. We've all seen this in forms before. The column would then shown each item like, Milk, Bread, Cheese - or something like that.
- OR -
Would it be better to have 6 columns with radio buttons or something for each item. Then I would have a VLOOKUP in another column that would list the items if the button were selected. And if you like this method, I will need guidance as to how to get my string of items.
Douglas,
for Data Validaton Contextures.com is the place to go:
I looked at this, Detlef, and had no idea how to start such a macro. I now feel completely lost.
