selecting multiple items from drop-down list

  • Thread starter Thread starter cs_hart
  • Start date Start date
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.
 
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

Back
Top