This example workbook shows how to create a temporary UserForm. The UserForm is created in the active workbook and deleted after use.
The workbook example shows how a table/database in an Excel worksheet can be filtered with user-defined criteria from the temporary dialog.
Note! Newer versions of Excel has a built in protection that prevents macro code from accessing the VBA project object model. This protection has to be disabled if you want this example to work. You can turn off the protection in the Excel Options dialog, where you find the Trust Center and can adjust the settings to trust access to the VBA project object model.
Click here to download this file.
Updated: 2002-04-02 Requires: XL97 File size: 23 kB