Insert Option Buttons

Step$6.$ We need to add an Option $($radio$)$ button to the sheet. The button will choose the type of conversion you want to perform, i$.$e$.,$ Feet to Meter or Meters to Feet. They are typically used for selecting mutually exclusive options such that only one option amongst two or more choices can be selected.

Step$7.$ To add a button 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.$

$2$

EECS$-1520$ Assignament $5$

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

Edit Text, and write Feet to Meters 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 Meters to Feet

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.