multiple choices in drop down boxes
 

I have tried using the following sub to allow to chose multiple selections
from a drop down list:
DV0017 - Select Multiple Items from Dropdown List-- Select multiple items
from a dropdown list; an event macro stores selections in adjacent cell, or
in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07.

I can only get it to work on one column in the spreadsheet. I need it to
work on multiple columns. What do I need to do?

multiple choices in drop down boxes
 

The sample on the SeparateRows sheet in that file works on different
columns, by using Select Case to check the column number. Perhaps you
could adapt that example.

Jeff H wrote:
I have tried using the following sub to allow to chose multiple selections
from a drop down list:
DV0017 - Select Multiple Items from Dropdown List-- Select multiple items
from a dropdown list; an event macro stores selections in adjacent cell, or
in same cell. DataValMultiSelect.zip 18kb updated 22-Feb-07.

I can only get it to work on one column in the spreadsheet. I need it to
work on multiple columns. What do I need to do?




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