Making multiple selections from Excel drop down lists

A

Andyroo

HI,

I can make a drop down list, however I need to be able to select more than
one option. Nay help would be great
 
A

Andyroo

I have the drop down list, from validation. One of the questions on my survey
has an option for the selection of more than one choice. Can anyone please
advise how I can do this. Many thanks
 
A

Andyroo

Debra, thank you for your reply.

I regret that I am a basic user. I can see not options in the validation
menu to do this. I am also not advancedf enough for the programming bit
(basis user) I dont know what to do other than enter the six options as drop
down list, six separate ones. But this makes data entry time consuming.

I am at my wits end !

Andrew
 
A

Andyroo

Debra,

Thankyou again. After much doodling and scrambling I just copied the code
and it works fine. Not sure how or why but it does.

Have a nice day
 
K

Karen

I have tried to copy the code, but it still isn't working - where did you
copy it to?
 
D

Debra Dalgleish

As answered in microsoft.public.excel.misc:

You can copy the code from the module in the sample file.
In your workbook, right-click on the sheet tab for the worksheet where
you have the data validation.
Choose View Code, and paste the copied code.

The code uses the Worksheet_Change event, and you can only have one
procedure with that name on each worksheet module.
 
Top