This section describes how to create form controls using SpreadsheetWEB form controls. If you have already created form controls using Excel's built-in form controls then you can skip this section because SpreadsheetWEB converts those automatically (This applies to Excel combo boxes, list boxes, Check Boxes and option buttons).
To create a Check Box, a list containing two items that point to "TRUE" and "FALSE" is necessary. This list must be created before the Wizard is started.
In the example below, the red shaded cells in the Excel spreadsheet will be formatted as Check Boxes.
Choose the "Check Box" input option for these cells in the SpreadsheetWEB Wizard.
A dialog window will appear and ask you to select the range of cells that contain the list items for the Check Box. By definition, the list can only contain two items that point to "TRUE" and "FALSE". However, SpreadsheetWEB is more flexible than Excel in the sense that you can create items such as "YES" and "NO" (i.e. you do not have to use the exact values "TRUE" and "FALSE").
The Check Boxes will look like this on the web page after conversion.
