Brian - Creating a option button

  • Thread starter Thread starter Excel
  • Start date Start date
E

Excel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Analyzing Results of a Survey Using Option Buttons 2
How do I activate an option button? 13
Help to create a macro 2
how to loop through option buttons 1
Controlling numerical values of option buttons in a group? 2
Creating a button in Macro 2
How to convert a .msg File? 2
Which is the Best Way to Delete large Attachments in Gmail? 1

Back
Top