Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Drop Down Boxes to Hide/Unhide Row | Excel Programming | |||
How do I create drop-down list boxes from multiple lists/headers | Excel Worksheet Functions | |||
Developing macro event to allow multiple choices on drop down menu | Excel Worksheet Functions | |||
Multiple dependent drop down boxes | Excel Discussion (Misc queries) | |||
Drop down list with multiple choices | Excel Worksheet Functions |