Populate ListBox with Filtered Range
Hi,
I would like to fill my listbox with the date of the filtered sheet (column A)
here's what I'm using currently
the problem I am having is that
Please Login or Register to view this content.
1. the header is showing the first data row not my headers
2. when the filters change, it doesnt add just the filtered
here's a sample file: Book1.xlsmitems
dont think you can use rowsource for what you are doing
also i found your listbox1 was way too small to show the data you were trying to get?
see attached possible solution
using loop for Rng of special cells visible then loop for Listbox add item
i tried to leave as much of your original code as possible without deleting it
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks