ActiveX Option Buttons

V

vecia

:confused:

Hello,

I need to know how to tell an option button what value to return.

I have a group of 4 option buttons and I have linked them all to th
same cell.

That's when they stop working, because they all want to say 'true' o
'false' - how do I get them to return a value instead (i.e. 1-4) so
can do a calculation on the value in the linked cell?

Please help
 
B

Bob Phillips

You can't. Link them to separate cells and use that to determine which has
been set.
 
E

Earl Kiosterud

Vecia,

If you only want the options buttons linked to a cell (and don't need code
behind them), you can use option buttons from the forms toolbar. Link them
to the same cell, and you'll get 1, 2, 3, etc, depending on which is on.
 
Top