Want to Show Filtered data in Listbox with Tickbox Option to Filter data

[HaroonSid]

HI,
Need help here please

I am using userform's textbox to filter my Range("A9:Y1000")

i want to show my filtered data only column(f) in listbox1 with Multiselect

for example
i type in textbox2 = "aam" then textbox will filter the field 2 and listbox1 will show filtered column(f)

[HaroonSid]

Fount this one to show only visible cells only in listbox

Please Login or Register  to view this content.

now i want only show only unique value in list box and want to apply multiselect items from listbox,
and using below to filter selected data from listbox

Please Login or Register  to view this content.

[HaroonSid]

check sample please

[HaroonSid]

this code is showing visible cells in listbox1

Please Login or Register  to view this content.

and this code showing unique values in listbox1

Please Login or Register  to view this content.

i need a mix version
visible cells + unique

[HaroonSid]

in this sample listbox1 is populating filtered and unique value with command button click

this code is filter listbox item (only one item ) when i click listbox

Please Login or Register  to view this content.

it i change listbox1 property
12.JPG

sample workbook
Multiselect = 1 - fmMultiselectMulti
then filtering is not working

[JohnTopley]

Try

Add highlighted line ....

in Private Sub CommandButton9_Click()

Please Login or Register  to view this content.