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

    Displaying on a userform (Office 2000)

    I have a table. I will be autofiltering the table and then displaying the filtered data on a userform. Any suggestion and/or code to assist. The filtered data will be about 5 columns and the number of rows can differ.

    Thanks

    Mario

  2. #2
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying on a userform (Office 2000)

    This was easy in Excel 5. If you can use a worksheet instead of a dialog, you can link the data. However, some controls do not work in a worksheet.

    Try the following and see if it might work for you. Copy a range of cells. Hold the shift key, select Edit, select Paste Picture Link. Now apply the autofilter on the original data. If you are carefull to not copy the top row of data (The titles), the dropdown arrows will not appear in the linked picture.

    Of course you can hide the gridlines, toolbars, row/column headings, scroll bars, etc, if you wish.

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Displaying on a userform (Office 2000)

    If you assign a dynamic range name to the visible cells in the table you could use this range name as the RowSource for your Form listbox.

    zeddy

Posting Permissions

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