Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
selecting multiple items from drop-down list
I have a data validation drop-down list with the values A through F. I
am trying to modify to allow selection of multiple values from the list. I created a macro using the code at http://www.contextures.com/excelfiles.html DV0017 but nothing seems to happen. I am an experienced programmer, but not with implementing excel macros. My understanding was I just needed to add this macro and it would be executed on every select. But I put a breakpoiint on the first executable lie and it never gets invoked. I followed the steps in excel for macros with no success. I must be overlooking something, but am unable to find out what. Any ideas appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
selecting multiple items from drop-down list
AFAICS it doesn't actually allow multiple selection in one go, it allows to
select one, then another and they all get appended to another list. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... I have a data validation drop-down list with the values A through F. I am trying to modify to allow selection of multiple values from the list. I created a macro using the code at http://www.contextures.com/excelfiles.html DV0017 but nothing seems to happen. I am an experienced programmer, but not with implementing excel macros. My understanding was I just needed to add this macro and it would be executed on every select. But I put a breakpoiint on the first executable lie and it never gets invoked. I followed the steps in excel for macros with no success. I must be overlooking something, but am unable to find out what. Any ideas appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
selecting multiple items in an excel drop down list | Excel Discussion (Misc queries) | |||
Selecting multiple items from a drop down list | Excel Discussion (Misc queries) | |||
Selecting a subset of items from a list | Excel Worksheet Functions | |||
Selecting items from a list. To transfer to another worksheet? | Excel Discussion (Misc queries) |