Objets
You can add controls and drawing objects to a worksheet by using the Insérer Contrôle and Insérer Object dessin menu options. After selecting the menu option, drag the pointer across the worksheet to define the area that the control will occupy. A dialog box will then be displayed that allows you to specify the attributes of the object.
To edit a control or drawing object, press the Ctrl key (on the keyboard) and then click on the object. This will select the object. Then you can use the Modifier Supprimer menu option or the Format Contrôle or Format Object dessin menu option, or you can drag the control to a different position or you can change the shape or size by dragging the border of the object. To deselect a selected object, press the Ctrl key and click on the object again, or select a different object, or click elsewhere on the worksheet. You can also use Tab or Shift+Tab to select the next or previous object.
The following control object types are supported:
Étiquette | A text label. |
Zone de groupe | A rectangle with an optional heading. Useful for grouping separate sets of option buttons together. |
Bouton de commande | A button that can be pressed. Useful for activating a macro. |
Case à cocher | A box that can be ticked or unticked. It can return a value of VRAI or FAUX to a linked cell to indicate its state. |
Bouton d'option | Usually one of a group of buttons that selects one of several items. Only one of the buttons in a group can be pressed at any one time. Use a group box object to define a button group. The group of buttons can return a value to a linked cell indicating the number of the button in the group that is currently pressed. |
Zone de liste | Displays a list of items from a range in the spreadsheet. It can return the number of the selected item to a linked cell. |
Zone de liste modifiable | Displays one of a list of items from a range in the spreadsheet. It can return the number of the selected item to a linked cell. |
Barre de défilement | A horizontal or vertical scroll bar. The orientation is determined by the shape of the rectangle when the control is first inserted. It can return the value of the current position to a linked cell. |
Toupie | A vertical spin control. It can return the current value to a linked cell. |
The following drawing object types are supported:
Ligne | A line or arrow. |
Rectangle | A rectangle that can be filled. |
Ellipse | An oval that can be filled. |
Zone de texte | A rectangle that can contain text. |
All of the objects can have a macro attached that will be run when the object is clicked on.