Display checkbox count in real time

hhh

New Member
Joined
Mar 15, 2011
Messages
12
Hi,

Any brothers can help.

I create 15 checkboxs in userform and need to display result of how many counts in real time. Example

Good Average Bad

Cakes Checkbox1 Checkbox2 Checkbox3

Pizza Checkbox4 Checkbox5 Checkbox6

KFC Checkbox7 Checkbox8 Checkbox9

Coke Checkbox10 Checkbox11 Checkbox12


Result count checkbox1,4,7,10 checkbox2,5,8,11 CheckBox3,6,9,12
realtime

Thanks:mad:
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,108,809
Messages
5,525,002
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top