CheckBox Query
 

Hi

I've got 14 checkboxes. Each one when ticked picks up a different se
of numbers. They don't however work cumulatively ie. click 3 boxes an
get the cumulative result. Is there a piece of coding I need to add t
eack of the checkbox macros???

Would appreciate some insight ;

--
TheDee
-----------------------------------------------------------------------
TheDeep's Profile: http://www.excelforum.com/member.php...fo&userid=2667
View this thread: http://www.excelforum.com/showthread.php?threadid=39944

CheckBox Query
 

I think you need to provide much more detail to get a useful
answer.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TheDeep"
wrote in message
...

Hi

I've got 14 checkboxes. Each one when ticked picks up a
different set
of numbers. They don't however work cumulatively ie. click 3
boxes and
get the cumulative result. Is there a piece of coding I need to
add to
eack of the checkbox macros???

Would appreciate some insight ;)


--
TheDeep
------------------------------------------------------------------------
TheDeep's Profile:
http://www.excelforum.com/member.php...o&userid=26675
View this thread:
http://www.excelforum.com/showthread...hreadid=399448

CheckBox Query
 

I assume you would use a formula with your checkboxes linked to cells

=A1*B1+A2*B2+A3*B3

so column A would be linked to your checkboxes and column b would contain
the corresponding numbers to add.

If you wanted to do the show column you could do

=sumif(A:A,True,B:B)

--
Regards,
Tom Ogilvy

"TheDeep" wrote in
message ...

Hi

I've got 14 checkboxes. Each one when ticked picks up a different set
of numbers. They don't however work cumulatively ie. click 3 boxes and
get the cumulative result. Is there a piece of coding I need to add to
eack of the checkbox macros???

Would appreciate some insight ;)


--
TheDeep
------------------------------------------------------------------------
TheDeep's Profile:
http://www.excelforum.com/member.php...o&userid=26675
View this thread: http://www.excelforum.com/showthread...hreadid=399448

CheckBox Query
 

If I understand correctly, Go to UserForm, view code, use the code
If CheckBox = True Then
Call the macro (This will run A macro within)
End If
The Check box Should be within Private sub Ok button User form
If the design say requires option say per row
within that row use the Esle If followed by the End if
Hope this is of some help?


"TheDeep" wrote:


Hi

I've got 14 checkboxes. Each one when ticked picks up a different set
of numbers. They don't however work cumulatively ie. click 3 boxes and
get the cumulative result. Is there a piece of coding I need to add to
eack of the checkbox macros???

Would appreciate some insight ;)


--
TheDeep
------------------------------------------------------------------------
TheDeep's Profile: http://www.excelforum.com/member.php...o&userid=26675
View this thread: http://www.excelforum.com/showthread...hreadid=399448