Setting up and check boxes in Excel

[terenceb]

Hi,

I am using Excel 2003 Pro. I have a form which has three columns (Yes , No , NA). I need to add check boxes to each row for each column. How do I set the properties so that checks can be selected. Also, I need to set up the check boxes so that if one is selected the other two are inactive. Finally, I need to total each column down dependant on whether the box is checked, of course.


Thanks

 

[dc20]

why not use radio buttons and then group them (thus only one could be selected).

 

[terenceb]

Sounds good, I'll try that.

 

[terenceb]

I have been able to add the radio buttons to the first row and group them, however when I add the second row of three radio buttons they all appear to be group together. What I mean is, if a click in one of the button on the first row and then on any of the buttons on the second row it deselects the first selected button and selects the second button clicked on. How can I get the rows to work independantly of each other?

 

[dc20]

You'll need to have a frame for each set of 3 radio buttons in order for them to act independently.

How many rows do you have on your form ?

 

[terenceb]

Approx. 30 rows. And I am unsure what you mean by frames.

 

[dc20]

I assumed you enclosed the 3 radio buttons with a frame (group box) in order to accomplish the grouping. The symbol on the control tools is a box with "xyz".

How did you "group" the 3 radio buttons ?

 

[terenceb]

I grouped the three buttons by highlighting each and right clicking them choosing grouping and group.

 

[dc20]

Do you have two threads going with the same subject ?

http://www.tek-tips.com/viewthread.cfm?qid=989295&page=1

 

[terenceb]

Yes,

One started at work and from home. Sorry!!!

 

[Asspin]

The frame control looks like a box with an xyz on the top.
-xyz-
| |
| | <--- like that lol
-----

Anyway, you want to either create the radio buttons in the frame, or you can copy and paste them into it.

From the help menu:
All option buttons in a Frame are mutually exclusive, so you can use the Frame to create an option group. You can also use a Frame to group controls with closely related contents.For example, in an application that processes customer orders, you might use a Frame to group the name, address, and account number of customers.

You can also use a Frame to create a group of toggle buttons, but the toggle buttons are not mutually exclusive.

The default event for a Frame is the Click event.