Running a cell formula only when a button is clicked

How can I have a cell run a formual only when a button is clicked?

I have a quiz spread sheet with drop-down lists for answers and cells that have a formula that checks the answers and displays "Correct" if the answer is right. The "Correct" is black on black to hide it, it's just there for the COUNTIF later.

I have cell F30 at the end with this formula: =COUNTIF(B5:J21, "Correct") which counts all instances of "Correct" and displays the total. I understand this needs a macro but my guess of F30=COUNTIF(B5:J21, "Correct") doesn't work.

How can I do this, please? Thanks.

Why do you need a macro to do this?

Originally Posted by StephenR

Why do you need a macro to do this?

Because right-clicking on my button gives me a context menu which includes "Assign Macro..." makes me think I need one to do it.

[QUOTE=StephenR;3019762]What I mean is, why don't you just put the formula in the cell manually?

Because I don't want the user to see the value until the button is clicked.

Originally Posted by StephenR

In any case you would need this:

Please Login or Register  to view this content.

That did it! Thank you! :-)