Creating controls on a spreadsheet

You can add the following controls to a spreadsheet:

Control
Description
Wordperfect Quattro Pro pgx ctpush Creating controls on a spreadsheet
Push button performs a specific action when clicked
Wordperfect Quattro Pro pgx ctckbox Creating controls on a spreadsheet
Check box provides two choices: Yes when enabled and No when disabled
Wordperfect Quattro Pro pgx ctradio Creating controls on a spreadsheet
Radio button typically used in a mutually exclusive list where only one radio button can be selected at a time
Wordperfect Quattro Pro pgx ctgrpbx Creating controls on a spreadsheet
Group box usually contains other controls, such as radio buttons or check boxes
Wordperfect Quattro Pro pgx ctlstbox Creating controls on a spreadsheet
List box lets a user browse values using a scroll bar
Wordperfect Quattro Pro pgx ctcombx Creating controls on a spreadsheet
Combo box creates a drop-down list box from which a user can make choices from
Wordperfect Quattro Pro pgx ctlabel Creating controls on a spreadsheet
Label text allows you to add static text near a control
Wordperfect Quattro Pro pgx ctvscrll Creating controls on a spreadsheet
Vertical scroll bar lets a user scroll through a list of values by clicking arrows
Wordperfect Quattro Pro pgx ctspin Creating controls on a spreadsheet
Spin control lets a user choose a value by clicking arrows and selecting a value
Wordperfect Quattro Pro pgx ctedfld Creating controls on a spreadsheet
Edit box lets a user type text

The way controls are activated varies depending on the action they incur. When you specify a source block to appear in a control (for example, a list box), each row in the block you specify becomes one item in a list. If you want to make a control functional, you must specify the appropriate information in a different area depending on the control.

You can attach a macro to a form control that runs when a user activates the control. For example, a user can click a button that runs a macro to perform a calculation. You can attach a macro to all form controls except group boxes and labels. For information about creating macros, see “Using macros.”

Form controls can also be attached to the Internet. For example, a button can launch a browser linked to a Web site. For information about using Quattro Pro notebooks with the Internet, see “Creating spreadsheets for the Web.”

In addition, you can link a custom dialog box to a form control so that when a user executes a macro, the specified dialog box displays.


To add a form control to a spreadsheet

Wordperfect Quattro Pro btnbacktotopproc Creating controls on a spreadsheet
1.
 
Click Insert Wordperfect Quattro Pro onestep Creating controls on a spreadsheet Form control, and click a form control.
2.
 
Click where you want the control to display.
3.
 
Drag diagonally until the control is the desired size.
You can also drag horizontally and vertically to create a different effect.

Wordperfect Quattro Pro tip Creating controls on a spreadsheet

•
 
To create a form control of the default size, position the pointer where you want the control to display, and click.

To attach a macro to a form control

Wordperfect Quattro Pro btnbacktotopproc Creating controls on a spreadsheet
1.
 
Select a form control.
2.
 
Right-click the control, and click Properties.
3.
 
Click the Macro tab.
4.
 
Type the macro command name or location in the Enter macro box.
You must enclose the macro command name with braces {}.

To attach a form control to the Internet

Wordperfect Quattro Pro btnbacktotopproc Creating controls on a spreadsheet
1.
 
Select a form control.
2.
 
Right-click the control, and click Properties.
3.
 
Click the Macro tab.
4.
 
Click Link to URL.
5.
 
Type the Internet address in the URL box.

To display a dialog box from a form control

Wordperfect Quattro Pro btnbacktotopproc Creating controls on a spreadsheet
1.
 
Select a form control.
2.
 
Right-click the control, and click Properties.
3.
 
Click the Macro tab.
4.
 
Click Execute dialog.
5.
 
In the Execute dialog box, choose a dialog box from the Active dialog list.
6.
 
Type a cell reference in the Result cell box.
7.
 
Type a cell reference in the Values range box.

Creating controls on a spreadsheet