Two Radio Buttons per Row 1

[cwsstins]

Working Excel 2000...I've got about 20 rows. Need to have two radio buttons on each row; one for Passed, one for Failed.

I've got that, but all the radio buttons are "linked" to each other so that only one can be selected at a time, rather than one in each row. I want to "link" each Passed/Failed on each row so one selection can be made for each row.

Any suggestions?

 

[sawedoff]

Use the option buttons from the Control Toolbox toolbar, then right click the button after inserting it. Go to the Properties window, and give the buttons in each group the same group name. One button in a each group can be selected.

Sawedoff

 

[cwsstins]

That did the trick...thanks!!!

 

[sawedoff]

Glad to help.

Sawedoff

 

[sawedoff]

It may be easier in your Excel sheet to put a column in with a flag. Then check the contents of the flag, and use 3 (or more)different IF-THEN fields. IF FLAG = 30 insert textA, If flag = 60, etc.

Sawedoff

 

[sawedoff]

Oops, replied to wrong question. Sorry.

Sawedoff