Page 210 - Excel Data Analysis

11 537547 Ch10.qxd 3/4/03 12:03 PM Page 196

EXCEL DATA ANALYSIS

VBA DIALOG BOX BASICS

very Microsoft Windows application uses dialog boxes in Excel to select a file to open. You can use VBA to create
to gather information from the user, and Excel is no dialog boxes that resemble those already in Excel. A good
E exception. You can create dialog boxes in the VBA reference book for creating VBA forms and dialog boxes is
Editor to request specific information from users. For Excel Programming: Your Visual Blueprint for Creating
example, you frequently interact with the Open dialog box Interactive Spreadsheets, 2002.

THE VISUAL BASIC EDITOR TOOLBOX

With the Visual Basic Editor, you can create custom dialog boxes that you
can use with your Excel macros. These custom dialog boxes are referred
to as UserForms in the Visual Basic Editor. When you create a UserForm,
you design it using the various controls available in the Toolbox.

ARROW BUTTON LABEL TEXT BOX COMBO BOX LIST BOX

CHECK BOX Toolbox FRAME

Controls

OPTION BUTTON COMMAND BUTTON

TOGGLE BUTTON TAB STRIP

MULTI PAGE SCROLL BAR SPIN BUTTON IMAGE REF EDIT

196