How to Select Multiple Items From an Excel Drop Down List?
I watched a video on how to do this and was successful. However, after saving the doc and re-opening it does not work anymore?
Do I have to do something special? I am not really familiar with macros or advanced excel for that matter. Any help is appreciated!
Last edited by Scarab21; 03-18-2021 at 06:53 PM.
The simplest code would be:
Please Login or Register to view this content.
Click the * to say thanks.
The code that I had worked but after I saved and then when back in - it didn't? Is it the code that is broken?
Here is the code I am working with. I tried the above code and it didn't work either? I have to be doing something wrong when I save the file maybe? Once I save the file it just stops working? I am a complete noob when it comes to this stuff in excel.
Please Login or Register to view this content.
Last edited by Glenn Kennedy; 03-19-2021 at 10:58 AM.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi there.
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
Nope - still didnt work
Glenn - I did read the banner. I tried to add an example doc but the options don't allow me to do so. I believe it is because I have never really posted a question. I usually just search. Unless I am jus a complete idiot and not seeing where I can attach?
I tested the code on a dummy sheet and it worked properly. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.
I am the idiot with the attachmentOne sec and I will post.
Here is the attachment
Try this version. Change the column number (in red) to suit your needs. Make sure you place the macro in the worksheet code module.
Please Login or Register to view this content.
What do you mean by "worksheet code module". I'm sorry, I am VERY green. I did add the above and it is still not working. Here is where I added your new version. Is that correct?
Attachment 724869
Your link doesn't work.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make your selections in column G.
So I promise I am not totally a dummy. I sent my file to someone who was like, I don't know what you are talking about...it works fine. I went back into my file today and it is working. I have no idea why? Microsoft updates? Any ideas?
This forum has been awesome for finding out how to do things. I'm sure everyone will cringe next time I have a question and sees my user name.
I REALLY appreciate all the help especially from you Mumps1.
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks