Hi Rick,

Im not using the Option Button because Im not that familiar with it (also
it does not have a simpleton link to each cell like the checkbox).
Additionally, Im trying to capture what each cell/checkbox reads out after
selected. This means if I have a group of 4 answers €“ Im looking to note the
answer selected to another page. So if someone chooses answer (checkbox 2),
Ive also set-up a formula on another page that captures that data for later
review. Thats why I was looking to put the constraints on the question
group. If someone checks more than one box, it pulls over multiple answers
and that screws up my data collection.

Is there any quick Macro you could help me with (still using the checkboxes)
that could assign each check box a value (for instance checkbox1 = 1 etc)?
That way, I could set up a validation Macro that would somehow state that 1
would bring up a msgbox letting them know they can only select one from the
group.

Thanks so much for your help and appreciate any further advice €“ Jenny B.


"Rick Rothstein (MVP - VB)" wrote:

What I need is a way to make
sure the User does NOT check 2 Boxes.

Why aren't you using Option Buttons then?

Rick