How to: Create a Custom Dialog Box
|Excel Developer Reference|
Use the following procedure to create a custom dialog box:
On the Insert menu in the Visual Basic Editor, click UserForm.
Find the control you want to add in the Toolbox and drag the control onto the form.
Right-click a control in design mode and click Properties to display the Properties window.
You can initialize controls in a procedure before you show a form, or you can add code to the Initialize event of the form.
All controls have a predefined set of events. For example, a command button has a Click event that occurs when the user clicks the command button. You can write event procedures that run when the events occur.
Use the Show method to display a UserForm.
Some properties can be set at run time. Changes made to the dialog box by the user are lost when the dialog box is closed.
- Displaying a Custom Dialog Box
- How to: Add Controls to a Document
- How to: Add Controls to a User Form
- How to: Create a User Form
- Initializing Control Properties
- Setting Control Properties
- Using ActiveX Controls on a Document
- Using ActiveX Controls on Sheets
- Using Control Values While Code Is Running