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
|