Make dropdown list with check box

[engmhelmy]

Dear All,

I want to make a drodown list with check boxes to select more than one choice can any one help ?Book5.xlsx

[Speshul]

You can use the Listbox ActiveX Control and change the properties to
MultiSelect = 1 - fmMultiSelectMulti
ListStyle = 1 - fmListStyleOption

[engmhelmy]

It is not working , could you demonstrate in the file ?

[Speshul]

Sorry can't upload from where I am!

Make sure you are using the ActiveX one, Fourth icon in the ActiveX Controls in Insert (on the developer tab)

Make sure Design Mode is selected

Right click and change properties

MultiSelect = 1 - fmMultiSelectMulti
ListStyle = 1 - fmListStyleOption
ListFillRange = The Data you wish to add (example, A1:A10) (note; you gotta type it, can't select cells from this window)

[engmhelmy]

it worked , but this is nto what i want ... i want a list like the autofilter list , any help ?