Command Button formula determiner

Here is an example based upon checkboxes (seeing as I recommended thatvbg.

Put this code in a macro and assign that macro to the checkbox

If ActiveSheet.CheckBoxes("Check Box 2").Value = xlOn Then
ActiveCell.FormulaR1C1 = "=SUM(RC[-10]:RC[-1])"
Else
ActiveCell.FormulaR1C1 = "=R1C1*17.5%"
End If


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"ADIGuy " wrote in message
...
Hello, thanks in advance for your help. I want to have a formula in a
cell change depending on weather a command button is depressed or not
(not depressed will run one formula; if depressed will run a different
formula). It can also be referencing a check box (does not have to be
a button). Can I do this? How?

Thanks!!


---
Message posted from http://www.ExcelForum.com/