Chechk box and formula in Excel ....

[EDD32]

Hi,

Is there a way i can link a check box with a formula.?

What i did is i put a check box on the excel sheet (using the Forms toolbox) and then if i say that 'if that check box is click then it should addup certain cells'...

is this possible?

thanks

[David_Jones]

One way would be to use the checkbox to change the value of a defined name from TRUE to FALSE (or 0 / 1 or whatever).

You can then use that defined name in a formula such as:

=if(checkbox=TRUE,sum(range),"Turned off")

or something similar.

HTH,

David.

[EDD32]

Originally posted by David_Jones One way would be to use the checkbox to change the value of a defined name from TRUE to FALSE (or 0 / 1 or whatever). You can then use that defined name in a formula such as: =if(checkbox=TRUE,sum(range),"Turned off") or something similar. HTH, David.

Olrighty I ll give this a go...thanks
btw, how can i embed the checkbox onto a particualr cell, for eg E4, rather than being a floating box?

cheers

[David_Jones]

Well - easiest is just to size it appropriately so that it covers exactly that one cell.

Perhaps you might be better making a cell a drop down selectable item using Data - Validation?

That avoids having to use the check box, and keeps it simple for non-expert users of Excel who might one day have to amend the model?

David.