[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???