Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Filter Named Range To Userform ListBox

  1. #1
    Join Date
    9th December 2007
    Posts
    14

    Filter Named Range To Userform ListBox

    Hi all,

    I've written a VBA userform which pulls data from a spreadsheet for call handling. The userform has a listbox which pulls it's info in from a named range on the spreadsheet. What I'd like to do is to be able to filter the listbox for different criteria - open calls, closed calls etc, but whenever I apply a filter on the spreadsheet, the listbox pulls in the hidden data as well as the visible data.

    Is what I'm trying to do possible?

    Also, is there a way of building in a search function which would allow users to search the data for a specific value? I know how I would do it in excel, but I'm unsure how to do this in VBA using user forms.

    N.B. I'm trying to keep to using userforms to make it more friendly for the end users, who are entirely non technical.

    Any help would be appreciated.

    TBO

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

    Re: Filter Named Range To Userform

    Use AdvancedFilter and Copy to another location with Dynamic Named Range that your ListBox gets its RowSource from.

  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Filter Named Range To Userform ListBox

    Hi,

    See the attachment.

    HTH
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  4. #4
    Join Date
    19th October 2010
    Posts
    11

    Re: Filter Named Range To Userform ListBox

    Thanks Krishnakumar, very good piece of code for me..
    Oguz

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Named Range Not Picked Up In Userform
    By dodger7 in forum Excel General
    Replies: 10
    Last Post: January 20th, 2007, 01:27
  2. Populating Listbox from a filtered named range
    By aggieman84 in forum Excel General
    Replies: 13
    Last Post: August 2nd, 2006, 11:37
  3. fill listbox on userform with a range name
    By mjschukas in forum Excel General
    Replies: 3
    Last Post: April 7th, 2006, 03:25
  4. Advanced Filter in macro hijacking named range
    By J88L in forum Excel General
    Replies: 2
    Last Post: December 21st, 2005, 01:32
  5. Populate ListBox Using Named Range RowSource
    By JJacob in forum Excel General
    Replies: 8
    Last Post: November 17th, 2004, 20:01

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
  •  
porno