View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
G Lykos G Lykos is offline
external usenet poster
 
Posts: 74
Default 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