• Displaying on a userform (Office 2000)

    Author
    Topic
    #369349

    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

    Viewing 1 reply thread
    Author
    Replies
    • #581319

      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.

    • #581583

      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

    Viewing 1 reply thread
    Reply To: Displaying on a userform (Office 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: