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).
The implementation of Option Buttons also requires that a list of items is created before the wizard is started. Follow the steps in the example below to see how you can create Option Buttons.
The red shaded area in the screenshot below highlights the cell, which is going to be formatted as an Option Button.
Choose the input type "Option Button" 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 Option Button. Similar to creating combo boxes, check boxes and list boxes, it is required that the list items for the Option Button are created before the Wizard is started. This list can be outside the range of cells that are going to be published on the web and can even be in a different worksheet.
In this example, the Option Button will look like this on the web page after conversion.
