Excel XP & Win XP
I'm trying to learn how to make a group of checkboxes in a UserForm mutually
exclusive (can check only one).
Looking in Help, it says to assign the same group name, in Properties, to
each checkbox. So I made up a simple UserForm with only 3 checkboxes and
one OK button, and assigned the same group name to each, "TheGroup".
Apparently I'm missing something because I can check all 3 boxes.
How do I make the 3 boxes mutually exclusive? Thanks for your time. Otto

That works for optionbuttons, but there is no support for this in Checkboxes
that I am aware of. You would have to use the click event and write code to
perform that functionality.

--
Regards,
Tom Ogilvy


"Otto Moehrbach" wrote:

Excel XP & Win XP
I'm trying to learn how to make a group of checkboxes in a UserForm mutually
exclusive (can check only one).
Looking in Help, it says to assign the same group name, in Properties, to
each checkbox. So I made up a simple UserForm with only 3 checkboxes and
one OK button, and assigned the same group name to each, "TheGroup".
Apparently I'm missing something because I can check all 3 boxes.
How do I make the 3 boxes mutually exclusive? Thanks for your time. Otto

Thanks Tom. Learning never ends. Otto
"Tom Ogilvy" wrote in message
...
That works for optionbuttons, but there is no support for this in
Checkboxes
that I am aware of. You would have to use the click event and write code
to
perform that functionality.

--
Regards,
Tom Ogilvy


"Otto Moehrbach" wrote:

Excel XP & Win XP
I'm trying to learn how to make a group of checkboxes in a UserForm
mutually
exclusive (can check only one).
Looking in Help, it says to assign the same group name, in Properties, to
each checkbox. So I made up a simple UserForm with only 3 checkboxes and
one OK button, and assigned the same group name to each, "TheGroup".
Apparently I'm missing something because I can check all 3 boxes.
How do I make the 3 boxes mutually exclusive? Thanks for your time.
Otto