UserForm Tips
- Using Controls on Worksheets
Discusses the differences between the two types of worksheet controls. - Disabling a UserForm's Close Button
Simple VBA code to prevent the user from closing a UserForm by clicking the "x" on the UserForm's title bar. - Creating a UserForm Programmatically
Describes a useful function the displays a list of OptionButtons derived from an array. The UserFrom and VBA code are created on the fly. - Adding a Hyperlink to a UserForm
A technique that lets you add Web or "mail to" hyperlinks to your Excel 97 UserForms. - Displaying a Chart in a UserForm
A technique that lets you display a chart as an image in a UserForm. - A Color Picker Dialog Box
A function that displays a dialog box that lets the user select a color. Uses a class module.
- Displaying a Menu of Worksheets to Print
A subroutine that creates a temporary dialog box that lists the names of each worksheet in a series of checkboxes. The user can then select which sheets to print. The technique can easily be adapted. - Filling a ListBox With Unique Items
A clever technique to fill a ListBox with non-duplicated items from a list. - Handle Multiple UserForm Buttons With One Subroutine
A technique that lets you create a single subroutine that is executed when any of several CommandButtons is clicked. Includes a sample file. Requires Excel 97. - An Enhanced Data Form
An Excel add-in that replicates the Data Form command - with lots of enhancements. The add-in is free, but access to the source code requires payment. - Creating a "Splash Screen" for an Excel Workbook
A simple technique that displays a dialog box for a specified period of time when your workbook is opened. - Importing and Exporting UserForms
Save time by creating a new "default" UserForm that contains an OK button and a Cancel button. - Displaying a Progress Indicator
How to display a graphical progress indicator in a dialog box. Requires Excel 97 or later. - Selecting a Directory:
Demonstrates how to display a dialog box to prompt the user for a directory. - General UserForm Tips:
General tips on working with UserForms.