Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of Radio Buttons
How do I get the radio buttons in my spreadsheet to properly function. At
this time, the user of my spreadsheet can only select ONE radio button on the entire sheet. How do I fix this?! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of Radio Buttons
Hi,
Put them inside a frame and the buttons in the frame act as a group and don't look if buttons in another frame are selected Mike "DR" wrote: How do I get the radio buttons in my spreadsheet to properly function. At this time, the user of my spreadsheet can only select ONE radio button on the entire sheet. How do I fix this?! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of Radio Buttons
Thank you for the below info - how do i "frame" them?
"Mike H" wrote: Hi, Put them inside a frame and the buttons in the frame act as a group and don't look if buttons in another frame are selected Mike "DR" wrote: How do I get the radio buttons in my spreadsheet to properly function. At this time, the user of my spreadsheet can only select ONE radio button on the entire sheet. How do I fix this?! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of Radio Buttons
Hi,
The simplest is using buttons from the 'Forms' toolbox. Put a Frame from the toolbox on your sheet and create buttons inside that frame and your done, From the 'Control' toolbox' put your buttons on your sheet and then right click each one and view properties. scroll doen and you will see they all belong to the same group which is the sheet name. Create groups by changing the group name on each button to the group you want it to belong to. Mike "DR" wrote: Thank you for the below info - how do i "frame" them? "Mike H" wrote: Hi, Put them inside a frame and the buttons in the frame act as a group and don't look if buttons in another frame are selected Mike "DR" wrote: How do I get the radio buttons in my spreadsheet to properly function. At this time, the user of my spreadsheet can only select ONE radio button on the entire sheet. How do I fix this?! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use of Radio Buttons
THANK YOU!
"Mike H" wrote: Hi, The simplest is using buttons from the 'Forms' toolbox. Put a Frame from the toolbox on your sheet and create buttons inside that frame and your done, From the 'Control' toolbox' put your buttons on your sheet and then right click each one and view properties. scroll doen and you will see they all belong to the same group which is the sheet name. Create groups by changing the group name on each button to the group you want it to belong to. Mike "DR" wrote: Thank you for the below info - how do i "frame" them? "Mike H" wrote: Hi, Put them inside a frame and the buttons in the frame act as a group and don't look if buttons in another frame are selected Mike "DR" wrote: How do I get the radio buttons in my spreadsheet to properly function. At this time, the user of my spreadsheet can only select ONE radio button on the entire sheet. How do I fix this?! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
radio Buttons | Excel Discussion (Misc queries) | |||
Radio Buttons | Excel Worksheet Functions | |||
Radio Buttons | Excel Worksheet Functions | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |