Displaying on a userform (Office 2000)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote