Checkbox - assign value/sum values ***HELP***

[suznal]

I hope someone can point me in the right direction.
​

Here is what I want to do.
​

When a user clicks on a command button in my worksheet it runs a function that adds the assigned values of all checkboxes that are true and displays the sum (either in a cell or msgbox). The resulting value is sort of like a service code, (think medical billing).
​

​

Something like this...
​

Checkboxes in column 1 (if true) - cb1 = 1000, cb2 = 2000 etc.
​

column 2 (if true) cb1 = 100, cb2 = 200 etc.
​

and so on, with one box from each column checked.
​

so column 1 box 1, and column 2 box 3, and column 3 box 2 would be 1320​

​

​

How do I do it???​