An event takes place whenever an option button is checked. This event then outputs a

number that is unique to the option button. Your implementation will use this number to

determine which button is checked and which conversion to perform. It would be best if

you associated a cell to see and use the unique output of each option button.

Step$11.$ To do this association, you must right$-$click one of the buttons,

ensuring the textbox appears around it$.$ Then, select Format Control. The

Format Control dialogue box appears. Select the Control tab and click the

Cell link box. Then click on cell B$2$ on the worksheet while the cursor is in

the Cell link box. $B$$2$ should appear in the cell link box. Click OK to

return to the worksheet. Repeat this procedure with the second option

button. Make sure cell B$2$ is also linked to this option button.

Step$12.$ Check the option buttons one after another and note the numbers

displayed in cell B$2.$ You will use these numbers in the next step. Name

cell B$2$ conversion$\_$type.

~ $4$ ~

EECS$-1520$ Assignment $5$

$3.$ Conversion Formula and Headings

Step$13.$ Give the cell B$5$ the name input. This is where the value to be

converted will be inputted.

Give the cell C$5$ the name output. It will hold the result of the conversion.

Step$14.$ Enter the conversion formula in cell C$5.$ The formula should

implement this statement: