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:

ÉtiquetteA text label.
Zone de groupeA rectangle with an optional heading. Useful for grouping separate sets of option buttons together.
Bouton de commandeA button that can be pressed. Useful for activating a macro.
Case à cocherA 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'optionUsually 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 listeDisplays 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 modifiableDisplays 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éfilementA 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.
ToupieA vertical spin control. It can return the current value to a linked cell.

The following drawing object types are supported:

LigneA line or arrow.
RectangleA rectangle that can be filled.
EllipseAn oval that can be filled.
Zone de texteA rectangle that can contain text.

All of the objects can have a macro attached that will be run when the object is clicked on.