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 these automatically (This applies to Excel combo boxes, List Boxes, check boxes and option buttons).
To create a List Box you must first prepare a list of items for the List Box before you start the Wizard. If you have already created a combo box, a check box or an option button, then you already know the setup procedure. The only difference is that you need to choose List Box as the input type in the SpreadsheetWEB Wizard.
The red shaded area in the screenshot below highlights the cell that is going to be formatted as a List Box.
Choose the input type "List Box" in the SpreadsheetWEB Wizard.
A dialog window will appear and ask you to select the range of cells that contains the list items for the List Box. Select the list you created before starting the Wizard.
In this example, the List Box will look like this on the web page after conversion.
Note: SpreadsheetWEB automatically skips all blank selections except for the first one when creating List Boxes. The first blank option is kept for preference formatting (i.e. so that the default box is empty instead of having the first value by default).