Quote:
Originally Posted by Debra Dalgleish
Another option is to do this with a data validation dropdown list and
programming. There's an example he
http://www.contextures.com/excelfiles.html
Under Data Validation, look for 'DV0017 - Select Multiple Items from
Dropdown List'
megs wrote:
I am making a survey and I need to have drop down boxes where more than one
answer can be chosen. Is this possible. If so how do I do it?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html |
MESSAGE for DEBRA DALGEISH
I have copied and used the code you provided. I changed it slightly for it to be applied to more than one column using the option Or (so now it is not only applied to column 16, but also to a number of other columns). I need help because now it is applying to ALL columns with a list option, even when I want some of these only to allow for ONE option to be picked and not multiple ones. What am I doing wrong? Could you help?
Thanks
Larocha