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

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

"Andyroo" wrote:

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

You can do this with data validation and programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'


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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

You can do this with data validation and programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'


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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

When I wrote, "Under Data Validation, look for 'Select Multiple Items
from Dropdown List'", I meant the Data Validation heading on this web page:

http://www.contextures.com/excelfiles.html

Here's a direct link to the file description:

http://www.contextures.com/excelfiles.html#DV0017

It uses programming, but you may be able to follow the example in the
file, to help you get started.

Andyroo wrote:
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

"Debra Dalgleish" wrote:


You can do this with data validation and programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'


Andyroo wrote:

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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

"Debra Dalgleish" wrote:

When I wrote, "Under Data Validation, look for 'Select Multiple Items
from Dropdown List'", I meant the Data Validation heading on this web page:

http://www.contextures.com/excelfiles.html

Here's a direct link to the file description:

http://www.contextures.com/excelfiles.html#DV0017

It uses programming, but you may be able to follow the example in the
file, to help you get started.

Andyroo wrote:
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

"Debra Dalgleish" wrote:


You can do this with data validation and programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'


Andyroo wrote:

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

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



"Andyroo" wrote:

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

"Debra Dalgleish" wrote:

When I wrote, "Under Data Validation, look for 'Select Multiple Items
from Dropdown List'", I meant the Data Validation heading on this web page:

http://www.contextures.com/excelfiles.html

Here's a direct link to the file description:

http://www.contextures.com/excelfiles.html#DV0017

It uses programming, but you may be able to follow the example in the
file, to help you get started.

Andyroo wrote:
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

"Debra Dalgleish" wrote:


You can do this with data validation and programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'


Andyroo wrote:

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html