Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
option group on excel sheet
Is it possible to establish an option group on a spreadsheet. Say a frame
with 3 radio button to give a frame value of 1, 2 or 3. In the same way as you would do on an access form. I can insert radio button but the only functionality I can get is a true or false to a linked cell. If so, how do you go about it? Bruce |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
option group on excel sheet
Use the Forms toolbar: first, create a "Group Box" (frame) then create the 3
buttons inside the group box. Having them in the group box links them together so they act in synch. Right click on one of the buttons and use Format Control to set the cell link. That cell should then give 1, 2 or 3 depending on the button selected. "Bruce" wrote: Is it possible to establish an option group on a spreadsheet. Say a frame with 3 radio button to give a frame value of 1, 2 or 3. In the same way as you would do on an access form. I can insert radio button but the only functionality I can get is a true or false to a linked cell. If so, how do you go about it? Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Group in excel | Excel Discussion (Misc queries) | |||
Excel: creating a group of independent option buttons | Excel Discussion (Misc queries) | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
Excel sort option disabled--file name followed by "group" at top . | Excel Discussion (Misc queries) | |||
Group Box with Option Buttons | Excel Programming |