Form Controls |
  
|
Form Controls |
|
To define the control properties, right-click it and select Shape explorer>Control.
In a set database in-row sheet the background of any "Cell link" is light yellow.
Press Enter to save each value.
The list or combo properties include:
▪Cell link: cell where the selected item number is returned
▪Input range: range where the itemized labels are taken
▪Drop down lines: count of items in the control (list).
The check box properties include:
▪Text: caption
▪Cell link: cell where the state FALSE / TRUE / #N/A is returned
▪Value: default state (unchecked, checked, indeterminate).
The appearance can be set in the section Fill.
The spinner properties include:
▪Cell link: cell where the count is returned
▪Value range: Minimum, Maximum, Small Change (unit step when clicking the black triangles; the value can still be entered using the keyboard), Large Change.
By default, any cell link is defined as an input field and the return value can be subject to tests; it shows in light yellow and can be invoked in another cell using a formula with the control name.
NOTE When the cell link is used for hiding/showing rows/columns/sheets, this does not work immediately, because it is not checked at the time the control is used.
Do not confuse the control name (Check box 2) and the cell link name (QDV_Control_2) that was used in the first QDV7 releases; refer to How to Manage Variables.
When a workbook is exported to Excel™, the controls are retained.