Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000 (Autofilter on Userform)

    I would like to autofilter a list in a worksheet and then publish it on a userform.

    Any ideas how to accomplish it.

    I thought of autofiltering the list on the worksheet, copying it to a knew worksheet and then with the add list funcion populate a listbox.

    The Data is 7 columns wide and can differ in row length of 5 to 50

    Any ideas/help would be appreciated

    Thanks

    Mario

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Excel 2000 (Autofilter on Userform)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Mario

    Your approach to filter the list, copy the filtered items, use Goto|Visible cells| and that would give you all the filtered items, then copy that selection and paste it into another worksheet.

    Then populate the UserForm control with that list.

    But when you say that you have 7 columns, does that mean you have 7 controls one gets populated from one of these columns?

    Also you say that the data can vary between 5 and 50 rows. Why do you see that as a concern?

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 (Autofilter on Userform)

    I would use the form Initilize event routine to load the Visible cells from the filtered range into the controls on the form.
    Legare Coleman

Posting Permissions

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