Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brian - Creating a option button
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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brian - Creating a option button
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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Button | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button | Excel Discussion (Misc queries) | |||
option button | Excel Discussion (Misc queries) | |||
Option Button | Excel Discussion (Misc queries) |