Step 1: Go to View, Toolbars and Forms on the Excel Toolbar

Step 2: Choose Option Button
Your cursor should be a thin cross. Move the cursor to where you want it in
the excel file and left click where you want it placed.

Step 3: Label you Option Button

Step 4: Link your button to a cell

Right Click on your button. Choose €œFormat Control€�. In the Cell Link put
the cell address you want to link to

"Excel" wrote:

Hi ,

I want to create an option button on excel file that would return a value of
number
1 in a cell that every time i click the option button a value in a cell
which correspond to number 1 will appear. can you help me on this thanks..