ActiveX Option Buttons

  • Thread starter Thread starter vecia
  • Start date Start date
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
 
You can't. Link them to separate cells and use that to determine which has
been set.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Radio Buttons - Values 1
Controlling numerical values of option buttons in a group? 2
Brian - Creating a option button 1
TRUE/FALSE MACRO using Option Buttons 1
ActiveX ToggleButton Reset 4
How do I activate an option button? 13
Excel Option buttons 3
Scrabble Value calculation for Welsh words 0

Back
Top