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

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

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

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

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

Regards,
Stefi

"NickHK" wrote:

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