Hi all,
I did search on line, but could not find what I need …
Using Excel VBA, I need to get on User Form's listbox advance filtered data form work sheet. I set named range on listbox’s RowSource property, so it shows named range from work sheet, let say data with 10 rows,. But when I filter that range & get less rows, let say 4 rows, the listbox again shows 10 rows, I would like to see on ListBox. 4 rows
Thank you in advance.
I did search on line, but could not find what I need …
Using Excel VBA, I need to get on User Form's listbox advance filtered data form work sheet. I set named range on listbox’s RowSource property, so it shows named range from work sheet, let say data with 10 rows,. But when I filter that range & get less rows, let say 4 rows, the listbox again shows 10 rows, I would like to see on ListBox. 4 rows
Thank you in advance.