XL: List of Controls That Can Be Placed on a Custom Dialog Box

Last reviewed: February 2, 1998
Article ID: Q141508
The information in this article applies to:

- Microsoft Excel for Windows, version 5.0 - Microsoft Excel for Macintosh, version 5.0 - Microsoft Excel for Windows NT, version 5.0 - Microsoft Excel for Windows 95, version 7.0

SUMMARY

The forms toolbar contains twelve different controls that you can place on a custom dialog box. To place one of these controls on a custom dialog box, click the button of the control you want. Drag the mouse pointer on the dialog box until the control is the desired size and shape.

MORE INFORMATION

The following table lists the controls and their descriptions.

   Control name            Description
   ---------------------------------------------------------------------

   Label                   Text provided for the user, such as names,
                           instructions, and cautions.

   Edit box                A box that allows a user to enter text, numbers,
                           or cell references.

   Group box               A border that separates a group of buttons or
                           other controls from the rest of the dialog box.

   Button                  A button such as Cancel or OK.

   Check box               A box that indicates whether an option has been
                           set, regardless of the state of other options on
                           the dialog box.

   Option button           A button for selecting one item from a group of
                           mutually exclusive options. Options can be
                           placed in a group box to group them together.

   List box                A list of text strings that allows for one or
                           more selections.

   Drop-down              A single non-editable text box and an down arrow,
                          paired with a drop-down list that appears after
                          the down arrow has been clicked.

   Combination            A single editable text box combined with a list
   list-edit              box.


   Combination drop-      An empty edit box with a down arrow, paired with
   down edit              a drop-down list that appears after the down
                          arrow has been clicked.

   Scroll bar             A horizontal or vertical scroll bar for changing
                          numeric values.

   Spinner                A pair of buttons for increasing or decreasing
                          a value.

REFERENCES

Microsoft Excel Version 7.0

For more information about custom dialog boxes, in Microsoft Excel, click Answer Wizard on the Help menu, and type the following

   creating a dialog

and click the Search button.

Microsoft Excel Version 5.0

"Visual Basic User's Guide," version 5.0, page 225


Additional query words: 7.00
Keywords : kbui
Version : WINDOWS: 5.0,7.0; MACINTOSH: 5.0
Platform : MACINTOSH WINDOWS
Issue type : kbhowto kbinfo


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.