[]
The Developer menu provides a rich set of form controls, including Button, Combo Box, Check Box, Spin Button, List Box, Option Button, Group Box, Label, and Scroll Bar. These controls can be easily added to worksheets to enable data entry, option selection, and user interface interaction.
Note: The Developer menu is only available when the EnhancedShapeEngine property is set to true in the Spread property panel on the right side of the Designer.
The options are explained in the table below.
Option | Icon | Description |
---|---|---|
Button | Used to trigger actions or events. | |
Combo Box | Combines a text box with a list box to create a drop-down list box. A combo box is more compact than a list box but requires the user to click the down arrow to display the list of items. Use a combo box to enable a user to either type an entry or choose only one item from the list. The control displays the current value in the text box, regardless of how that value is entered. | |
Check Box | Turns on or off a value that indicates an opposite and unambiguous choice. You can select more than one check box on a worksheet or in a group box. | |
Spin Button | Increases or decreases a value, such as a number increment, time, or date. To increase the value, click the up arrow; to decrease the value, click the down arrow. | |
List Box | Displays a list of one or more items of text from which a user can choose. | |
Option Button | Allows a single choice within a limited set of mutually exclusive choices; an option button is usually contained in a group box or a frame. | |
Group Box | Groups related controls into one visual unit in a rectangle with an optional label. Typically, option buttons, check boxes, or closely related contents are grouped. | |
Label | Identifies the purpose of a cell or text box, or displays descriptive text (such as titles, captions, pictures) or brief instructions. | |
Scroll Bar | Scrolls through a range of values when you click the scroll arrows or drag the scroll box. |