Check box in excel

[G2K]

Hi all,

i want to use checkboxes in excel sheet to rate my associates from 1 to 5 by clients selection of checkboxes. below is sample data

<TABLE dir=ltr borderColor=#07ad00 cellSpacing=1 cellPadding=2 width=503 border=1><TBODY><TR><TD width="15%" height=16>Criteria 1

​

</TD><TD width="17%" height=16>CheckBox1

​

</TD><TD width="17%" height=16>CheckBox2

​

</TD><TD width="17%" height=16>CheckBox3

​

</TD><TD width="17%" height=16>CheckBox4

​

</TD><TD width="17%" height=16>CheckBox5

​

</TD></TR><TR><TD width="15%" height=16>Criteria 2

​

</TD><TD width="17%" height=16>CheckBox6

​

</TD><TD width="17%" height=16>CheckBox6

​

</TD><TD width="17%" height=16>CheckBox6

​

</TD><TD width="17%" height=16>CheckBox6

​

</TD><TD width="17%" height=16>CheckBox6

​

</TD></TR><TR><TD width="15%" height=16>Criteria 3

​

</TD><TD width="17%" height=16>CheckBox11

​

</TD><TD width="17%" height=16>CheckBox11

​

</TD><TD width="17%" height=16>CheckBox11

​

</TD><TD width="17%" height=16>CheckBox11

​

</TD><TD width="17%" height=16>CheckBox11

​

</TD></TR><TR><TD width="15%" height=16>Criteria 4

​

</TD><TD width="17%" height=16>CheckBox16

​

</TD><TD width="17%" height=16>CheckBox16

​

</TD><TD width="17%" height=16>CheckBox16

​

</TD><TD width="17%" height=16>CheckBox16

​

</TD><TD width="17%" height=16>CheckBox16

​

</TD></TR><TR><TD width="15%" height=16>Criteria 5

​

</TD><TD width="17%" height=16>CheckBox21

​

</TD><TD width="17%" height=16>CheckBox21

​

</TD><TD width="17%" height=16>CheckBox21

​

</TD><TD width="17%" height=16>CheckBox21

​

</TD><TD width="17%" height=16>CheckBox21

</TD></TR></TBODY></TABLE>​

i want to allow user to select only one checkbox in a row.

i have to calculate the associate score based on this selection. the scores is 1 to 5(left to right)

how to calculate value on the basis of user selection?

is there any option to group the checkbox so that grouped checkboxes behave like option button?

if no,how to contol it in VBA.

please help........

thanks

 

[Andrew Poulsom]

Why don't you use OptionButtons? Those from the Control Toolbox have a GroupName property that you can use to assign grouping.

 

[id107]

A group of option buttons would be much easier, but if you have to have checkboxes:

Private Sub CheckBox1_Click()
CheckBox2 = 0
CheckBox3 = 0
CheckBox4 = 0
CheckBox5 = 0
End Sub

But you're going to have to have to edit that for every checkbox and it's really not going to be pretty.