SpreadCE Help

Objects

You can add controls and drawing objects to a worksheet by using the Insert Control and Insert Drawing 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 Edit Delete menu option or the Format Control or Format Drawing 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:

Label | A text label.
Group box | A rectangle with an optional heading. Useful for grouping separate sets of option buttons together.
Command button | A button that can be pressed. Useful for activating a macro.
Check box | A box that can be ticked or unticked. It can return a value of TRUE or FALSE to a linked cell to indicate its state.
Option button | 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.
List box | Displays a list of items from a range in the spreadsheet. It can return the number of the selected item to a linked cell.
Combo box | 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.
Scroll bar | 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.
Spin control | A vertical spin control. It can return the current value to a linked cell.

The following drawing object types are supported:

Line | A line or arrow.
Rectangle | A rectangle that can be filled.
Oval | An oval that can be filled.
Text box | 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.