$1.$ Insert Option Buttons

Step$6.$ Click on the developer tab and select the Option $($radio$)$ buttons. The

button will choose the type of conversion you want to perform, i$.$e$.,$

Fahrenheit to Celsius or Celsius to Fahrenheit. They are typically used

for selecting mutually exclusive options such that only one option

amongst two or more choices can be selected.

Step$7.$ Click Insert within the Developer ribbon and select Option Button

under

Form Controls. Cursor changes to a thin cross. Click anywhere on the

worksheet to place the option button. See Figure $1.$

~ $3$ ~

EECS$-1520$ Assignment $5$

Figure $1$ Select Option

Button

Step$8.$ Right$-$click the option button to select it and reveal options to edit it$.$

Select

Edit Text, and write Fahrenheit to Celsius to replace the default text

Step$9.$ You can select the option button, copy and paste it to create a second

option button, or just create another using the previous steps. Change its

text to Celsius to Fahrenheit

Step$10.$ Select the two option buttons and use their handles to move them to

occupy the merged cells B$3$ & C$3.$ Arrange them suitably to give them a

nice look.

$2.$ Set$-$up the option buttons

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. Click 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.