+ Reply to Thread
Results 1 to 2 of 2

Using the auto-filter selection form on arrays

  1. #1
    Registered User
    Join Date
    09-15-2011
    Location
    Surrey
    MS-Off Ver
    Excel 2003
    Posts
    25

    Using the auto-filter selection form on arrays

    On Excel 2007 and 2010 there is a selection form on the auto filter

    The selection form allows the user to select a number of entries to use as a filter.

    I need to use the same mechanism on an internal array in VBA

    In effect, I want to have an initial array where the autofilter user form appears and allows the user to select which items I require. On accepting the selections, I would require a smaller array that included only the items matching the selection.

    What is the VBA function/call that will allow me to use this mechanism on an array, rather than a column in a table?

    Thanks in advance

    Ian
    Last edited by Perception; 09-26-2011 at 08:55 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,064

    Re: Using the auto-filter selection form on arrays

    To use that, you would have to populate a range on a sheet, add a filter, then iterate the visible items afterwards. It would be simpler to use a userform with a listbox set to allow multiselect.
    Everyone who confuses correlation and causation ends up dead.

+ 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