more than two optionbuttons in a group

[Stefi]

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

 

[Bob Phillips]

Use option buttons from the Forms toolbar.

--
HTH

Bob Phillips

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

 

[Stefi]

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

 

[NickHK]

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]

Thanks Nick, I should have never thought of that! A little bit complicated
but this is what I was looking for!

Regards,
Stefi