View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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