Controls, Dialog Boxes, and Forms

This topic links to programming tasks (how-to and walkthrough topics) for common controls, dialog boxes, and forms scenarios.

"How Do I ..." is your gateway to key task-based topics about programming and application development using Excel. The links provide pointers to important, procedure-based help topics.

Controls, Dialog Boxes, and Forms

• Add a Unique List of Values to a Combo Box

  • Describes how to take a list from a spreadsheet and use it to populate a combo box control using only the unique values.

• How to: Add Controls to a Document

  • Describes how to add controls to a document.

• How to: Add Controls to a User Form

  • Describes how to add controls to a user form.

• Automatically Dismiss a Message Box

  • Describes how to automatically dismiss a message box.

• How to: Create a Custom Dialog Box

  • Describes how to create a custom dialog box.

• Create a Custom Menu That Calls a Macro

  • Describes how to create a custom menu with four menu options, each of which calls a macro.

• How to: Create a User Form

  • Describes how to create a user form.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.