calculate in userbox fopr checkbox

[hhh]

Hi,

I believe many experts here can help me. I think of how to do it for many days but do not know answer.

I creating userform in Excel and can key in many people for survey. In the userform, user will click in checkbox on their preferences. They will click one of checkbox whether Good, average or Bad.
I need something to count number of checkbox column in each
Example:

Good Average Bad
Cake Checkbox 1 checkbox2 Checkbox 3

Pizza Checkbox 4 checkbox5 Checkbox 6

Currypuff Checkbox 7 checkbox8 Checkbox 9


Result count how many click Good AND AVERGAE AND BAD IN EACH COLUMN.THANKS

Please see attached.

Thanks

 

[mikerickson]

Something like

Dim GoodCount as Long, AvgCount as Long, BadCount As Long

With UserForm1
    GoodCount = -(.CheckBox1.Value + .CheckBox4.Value + .CheckBox7.Value)
    AvgCount = -(.CheckBox2.Value + .CheckBox5.Value + .CheckBox8.Value)
    BadCount = -(.CheckBox3.Value + .CheckBox6.Value + .CheckBox9.Value)
End With

 

[hhh]

Hi,

May I know where I should insert this code.

Thanks

 

[mikerickson]

At the the point in your code where you need to calculate the results.

 

[hhh]

Hi,

I need to display this 3 result of Good, Average and Bad in real time in userform.

Anybody can help

 

[mikerickson]

If you need to do it as they mark it, the code should be triggered by the CheckBox change events.