Excel: How to add multi-selection listbox for data validation list

**gaikwad.mm@gmail.com** · 05-09-2013, 03:24 AM

Dear expert

i am having an excel file with data validation with multi-selection from drop down.

But my concern is - user needs to select single-single items each time and i want to get all the selection at a time as we are having this functionality in pivot tables that we can multi select items at a time.

Any help will be appreciated

thanks
mg

**:) Sixthsense :)** · 05-09-2013, 03:39 AM

Check The below Link For Details:-
http://www.contextures.com/excel-dat...-multiple.html

**gaikwad.mm@gmail.com** · 05-09-2013, 03:44 AM

Hello

Sixthsense

Actually I' am using the same code for Multi-Selection

But my requirement is..., in the drop down I' should get a list with Check Box where I' can select the required multiple items.

Example:

2013-05-09_131120.jpg

Please help me on this

Thanks
MG

**:) Sixthsense :)** · 05-09-2013, 03:49 AM

In Validation You Can't Do what you shown in Post # 3 screenshot

**gaikwad.mm@gmail.com** · 05-09-2013, 03:56 AM

Ohh!!!

So is there any way to get some workaround to save time.

like can we use user form with list box.

if yes? could you please help me with an example.

also I' don't want to do modification in my existing codes.

- Can we do online chat in this forum - I' mean real time chant and NO MESSAGES?

Thanks
MG