+ Reply to Thread
Results 1 to 3 of 3

Help with autofilter

Hybrid View

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Help with autofilter

    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.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486

    Re: Help with autofilter

    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

  3. #3
    Registered User
    Join Date
    03-06-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Help with autofilter

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1