Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to backfeed radio buttons?
Greetings! Am working on someone else's code in which they set the cell
value underlying a pair of radio buttons. It turns out that the radio buttons don't track the cell value - they apparently only set it upon button selection, otherwise are disengaged, leading to a situation where the buttons indicate one selection but the cell value indicates another. What are options for manipulating the radio buttons from the VBA side of the fence? Interest is to change from one selection to another, and have the cell value correspond. Causing the buttons to track the cell value might be most desirable if not painful. Firing a button-sychronize operation when setting the cell value is another thought. Thanks, George |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How are radio buttons logically connected?
In playing with this further, it appears that the radio buttons do in fact
track the cell value, so please disregard my previous question. There is, however, another question resulting from this. The several buttons are somehow logically linked. I can copy the second button and create a third, and all three are linked, and if I change the cell reference in the third, it changes the cell reference for all three. However, I can't see how to tell what is linked to what. So, second question is: how do you establish, and once it is done see, which radio buttons are grouped together. Thanks, George "G Lykos" wrote in message ... Greetings! Am working on someone else's code in which they set the cell value underlying a pair of radio buttons. It turns out that the radio buttons don't track the cell value - they apparently only set it upon button selection, otherwise are disengaged, leading to a situation where the buttons indicate one selection but the cell value indicates another. What are options for manipulating the radio buttons from the VBA side of the fence? Interest is to change from one selection to another, and have the cell value correspond. Causing the buttons to track the cell value might be most desirable if not painful. Firing a button-sychronize operation when setting the cell value is another thought. Thanks, George |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How are radio buttons logically connected?
On Sat, 3 Jun 2006 13:25:01 -0700, "G Lykos" wrote:
There is, however, another question resulting from this. The several buttons are somehow logically linked. I can copy the second button and create a third, and all three are linked, and if I change the cell reference in the third, it changes the cell reference for all three. However, I can't see how to tell what is linked to what. So, second question is: how do you establish, and once it is done see, which radio buttons are grouped together. By default all on a page are linked. If you want multiple groups on a page what you do depends on whether they come from the Control Toolbox or the Forms Toolbar. On the Control ones there is a property called GroupName. By default it has the sheet name. You can change it. If from Forms then you have to use a Forms frame around them to keep them in the same group. Don <www.donwiss.com (e-mail link at home page bottom). |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How are radio buttons logically connected?
Thanks, Don. Poked around some more, discovered that a Forms group box's
name is shown in the Name Box when selected. Turns out that this (vs. Control Toolbox - is that ActiveX?) is how the worksheet I'm working on was set up. Regards, George "Don Wiss" wrote in message ... On Sat, 3 Jun 2006 13:25:01 -0700, "G Lykos" wrote: There is, however, another question resulting from this. The several buttons are somehow logically linked. I can copy the second button and create a third, and all three are linked, and if I change the cell reference in the third, it changes the cell reference for all three. However, I can't see how to tell what is linked to what. So, second question is: how do you establish, and once it is done see, which radio buttons are grouped together. By default all on a page are linked. If you want multiple groups on a page what you do depends on whether they come from the Control Toolbox or the Forms Toolbar. On the Control ones there is a property called GroupName. By default it has the sheet name. You can change it. If from Forms then you have to use a Forms frame around them to keep them in the same group. Don <www.donwiss.com (e-mail link at home page bottom). |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How are radio buttons logically connected?
On Sun, 4 Jun 2006 14:26:16 -0700, "G Lykos" wrote:
Thanks, Don. Poked around some more, discovered that a Forms group box's name is shown in the Name Box when selected. Turns out that this (vs. Control Toolbox - is that ActiveX?) is how the worksheet I'm working on was set up. I think the Control Toolbox is ActiveX. I only use something from there if I have to. And the only reason I have to is when I want to hide the thing when I hide the rows. Some from the Forms toolbar don't allow resizing, and resizing is what lets it be hidden. Forms buttons do, so I can't see ever using a button from the Control Toolbox. In the Name Box is the name of the option button. It has to be unique so you can set its properties. The Group Box is what I called a Frame in my reply. If you right click on it, then yes its name appears there. Don <www.donwiss.com (e-mail link at home page bottom). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Radio buttons | Excel Discussion (Misc queries) | |||
Use of Radio Buttons | Excel Discussion (Misc queries) | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Radio Buttons | Excel Worksheet Functions | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |