selecting multiple items from drop-down list

C

cs_hart

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.
 
B

Bob Phillips

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)
 

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