multiple choices in drop down boxes

J

Jeff H

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?
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top