View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default more than two optionbuttons in a group

Stefi,
If you set all the options buttons in question to the same GroupName, giving
each their own LinkedCell, you can have as many as you need .
You would then some formula and/or helper cell to convert to the True value
to a numeric.

NickHK

"Stefi" wrote in message
...
Thanks Bob, I don't understand the reason why MS developers chose this
unreasonable solution but I'll do that not being other possibility...

Regards,
Stefi

"Bob Phillips" wrote:

Use option buttons from the Forms toolbar.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Stefi" wrote in message
...
Hi All,

I thought that optionbuttons behave like radio buttons in other

programming
environments, but I'm experiencing that optionbuttons (even if there

are
more
than 2 of them) within the same group set the linked cell to

TRUE/FALSE .

How can I achieve that a 3 or more member optionbutton group set the

linked
cell to 1,2,3,... respectively depending on which optionbutton was

clicked?
Or what is the method to create a selection structure with more than 2
choices?

Thanks,
Stefi