• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help in creating a Drop-Down list with CheckBoxes that allows for Multiple choice selections.

A

amohan826

New Member
I'm in the middle of preparing a dynamic dashboard that will have many drop-down lists. These lists will act as filters based on which I will be able to display my charts. (No I can't use Pivot Table because the data cannot be aggregated using Pivot as the Logic is quite complicated and can't be generally summarized.) My pain point is the drop-down list with the *CheckBox* functionality.

Those dropdown lists are special in that, they will have name of the items along with a "CheckBox" which will allow for multiple selections. (Just like the one we see in AutoFilters, basically).

Can you suggest some head-starts where I can begin?

I have tried comboboxes, listboxes and data validation but they do not meet the use case functionality that I want.
 
If the issue is using a ListBox to make multiple selections from the displayed list, you can abandon your checkbox idea and instead use the ListBox "MultiSelect" property.

1698523576292.png
 
You must log in or register to reply here.
Back
Top