HELP: CHECKBOX

[evlai]

I am new to the Excel VBA. I need to know how to use checkbox if i click on "EMEA" then range G15 will calculate the total sales of EMEA. if i click on all three checkboxes, range G15 will cacalte the total sales of all region.

I am attaching the file in this post for clearer picture. Thanks

Please help. Thanks

Attachment 2862

[Andy Pope]

Hi,

Do you really need VBA for this?
This formula in G15

=SUMPRODUCT((($A$2:$A$11="EMEA")*($B$2:$B$11)*--B14)+(($A$2:$A$11="AMF")*($B$2:$B$11)*--B16)+(($A$2:$A$11="APJ")*($B$2:$B$11)*--B18))

With the checkboxes link to cells B14,B16 and B18 will give you the totals.

[Bob Phillips]

Here is a solution

[evlai]

thanks, u r the best!!

[Andy Pope]

Hi xld,

Your code is in another workbook. Book1.xls!CalcTotals