Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
How to have Checkbox A uncheck with checked Checkbox B | Excel Discussion (Misc queries) |