O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Custom Dialog Boxes

All the Office VBAs contain extensive tools for creating and controlling custom dialog boxes. VBA calls them UserForms but they have absolutely nothing to do with Word or Excel data-entry forms.

VBA custom dialog boxes can do anything any Windows dialog boxes or Office dialog boxes can do, without exception. You can create custom dialog boxes to ask for user input, have the user make choices, let them navigate to a file or folder, or warn them of questionable actions, for example.

All the items you're accustomed to seeing on Windows dialog boxes (they're called "controls") are available in VBA: pushbuttons, check boxes, radio buttons (option buttons), pictures, text boxes, tabs, and so on.

In general, when you want ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required