Thread: Check Boxes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve-Westlake[_2_] Steve-Westlake[_2_] is offline
external usenet poster
 
Posts: 2
Default Check Boxes

Excelent. Thank you for your help. When I set the groupnames the way i wanted
them to be, I then created a copy of the master sheet but the new sheets
radios are still "linked" to the origianl page. Is there a quicker way than
changing each radio manually for each copied page? I've created everything
via the control toolbox.

Thank you for your time and help,
Steve


"Dave Peterson" wrote:

First, if you're only allowing Yes and No, just use a single checkbox that
represents Yes. If it's unchecked, then that means No.

But if you want to use two objects, you can use two option buttons.

If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons.

If you use optionbuttons from the control toolbox toolbar, rightclick on each
of the members of the group, choose properties, and give that group a unique
groupname.

Steve-Westlake wrote:

I have 2 check boxes in a cell. CB1 says yes and CB2 says no. I want only 1
to have a check mark at any given time. if 1 box is checked and i decide to
click the other box, i want the first check mark to disappear upon clicking
box #2.


--

Dave Peterson