Can Not Check more than 1 check box

[jamphan]

I have a series of check boxes on a template. What I would like is for the user to be able to select only one check box and possibly a message box would appear if they tried to select more than one. Is this possible?

[Chip Pearson]

You should be using OptionButtons rather than CheckBoxes. With
OptionButtons, only one may be selected at a time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jamphan" <[email protected]>
wrote in message
news:[email protected]...
>
> I have a series of check boxes on a template. What I would
> like is for
> the user to be able to select only one check box and possibly a
> message
> box would appear if they tried to select more than one. Is
> this
> possible?
>
>
> --
> jamphan
> ------------------------------------------------------------------------
> jamphan's Profile:
> http://www.excelforum.com/member.php...o&userid=20105
> View this thread:
> http://www.excelforum.com/showthread...hreadid=539294
>