Excel Reference

Controls, Dialog Boxes, and Forms

Direct Answer

Controls, Dialog Boxes, and Forms
is part of the Excel VBA object model. This reference page documents its syntax, parameters, and typical usage.

Reference

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.

!include[Support and feedback]

Reference: Excel object-model documentation • updated 06/08/2017
. Rebuilt for readability; see the original for complete parameter matrices.