Hello all...I was wondering if anyone new how to autofilter a spreadsheet based on inputs from a Listbox in a userform? The big issue seems to be when making the Listbox multi-select capturing those values into an array that is used to filter by.
Hello all...I was wondering if anyone new how to autofilter a spreadsheet based on inputs from a Listbox in a userform? The big issue seems to be when making the Listbox multi-select capturing those values into an array that is used to filter by.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
i appreciate any help or suggestions. I am new to VBA and this has been eating my lunch for while
I have attached a desensitized version of my unsuccessful attempt to filter a spreadsheet based on Listbox selected values. Even though I have code to preserve the selection and add an additional selection as an array, it only uses the first value selected. In this case I want to select to years 2013 and 2014, and have it filter column A by those two years.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks