Populate a Listbox with Unique data of filtered range

hi,
i am using below code to populate data with unique data of range f10:f1000

Please Login or Register  to view this content.

i want to change above code to apply at filtered data

i want to show unique values of filtered data only

thank you

From what I see the listbox already shows only unique values?

HaroonSid,

If what you mean is you only want to see unique values on the sheet, then add

Please Login or Register  to view this content.

just before the "End With" line in the userform initialize code

If you want the listbox click code to only select visible cells too, I would suggest this

Please Login or Register  to view this content.

@ xlnitwit
Thank you very very much

best regards
Mohd Haroon