Checkbox in dropdown list

Question

I have a table in excel where I can select multiple items from a dropdown list in one cell.

Now, using my macro I have to pick all of the options separately, and they are added to a cell one by one.

Is there a possibility to write the macro that adds checkboxes to the dropdown list, so I could check the items I want to add and they will be added simultaneously?

Solution

Yes, you can add a form listbox and allow multiple selections. Check here for MS support.

VBA - check this stackoverflow thread

Comments

[Padrick22]

OK I did as you suggested, it works but i have one more problem: The elements that I Choose appear one ofter another (when I choose test1 and test2 it shows in a cell like "test1test2), is there a possibility to chenage it somwhere in listbox properties, to, for example put it with a comma (test1, test2)?

[Raystafarian]

Using an activeX control and VBA? Are you concatenating the output?

[Scott - Слава Україні]

If you post a link to a web site that you own,  you must say that it is yours.

[Aviral Mittal]

Yes, it is my web site. I own www.vlsiip.com

[Scott - Слава Україні]

Yes, I know (but thanks for acknowledging it).  You may mention it in your profile page without restriction, because we assume that everything in your profile page is about you.  What I’m telling you is that every time you mention the site in an answer (or a question), you must say that it is yours in the post — doing it in a comment is not enough.  Also, you should not mention it in every answer you write (I would say, off the top of my head, … (Cont’d)

[Scott - Слава Україні]

(Cont’d) …  that you should limit yourself to about 20% — but that’s not official) and you should definitely avoid adding it to somebody else’s answer.   Excessive promotion of your own web site will be seen as spam, and will lead to answers being deleted, new answers being blocked (refused), and possibly the deletion of your account.   I advise you to take the site “tour” to get an overview of the rules.

[Scott - Слава Україні]

P.S. I almost forgot to mention: when you answer a question on Super User, you should answer the question on Super User. Posts that say “yes, it’s possible; follow this link to see how” are unacceptable and will be deleted, even if the link is to somewhere like microsoft.com or mozilla.org. If you want to control who sees your code and other pearls of wisdom, then maybe Super User isn’t the place for you.   P.P.S. Your site has many typos: “i” (should be “I”), Lets (→ Let’s), wont (→ won’t), ahve (→ have), anywehre, deliberatly, doubble, follwing, mulitple, Selet, shd, Shee1, th3, Toolsbox, welcome.