Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Copying worksheet data to a list box

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Kansas City, MO
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    1st userform is set up to adjust the autofilter in a worksheet, the next button enters these changes and calls up the 2nd userform which should display the new filtered list, BUT the listbox in the 2nd userform keeps displaying the original unfiltered data??? Is there some process in VBA that loads the listbox before performing the filter operations? How can i prevent this from happening and only load the listbox with the filtered data that is working in the worksheet, but not reflected in the listbox... thanks for any help

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-20 12:52, datastream wrote:
    1st userform is set up to adjust the autofilter in a worksheet, the next button enters these changes and calls up the 2nd userform which should display the new filtered list, BUT the listbox in the 2nd userform keeps displaying the original unfiltered data??? Is there some process in VBA that loads the listbox before performing the filter operations? How can i prevent this from happening and only load the listbox with the filtered data that is working in the worksheet, but not reflected in the listbox... thanks for any help
    If I understand you correctly.
    The listbox will only show data that you have
    assigned to it weather that is from a
    predefined sheet range or an array of values
    you have set up. When you have autofiltered the range, the Data in the listbox will still show your entire data
    range. To only show the filtered list you
    will have to reload this filterd list into
    the listbox after it is filtered.

    Do a search here for Autofilter show visble

    Or repost for help
    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Kansas City, MO
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ya, thanks for the advice. one alternative i had was just to copy the results into a new worksheet and have the listbox display off of that sheet. but was trying to avoid the extra work.
    john

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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