Calculate total at a press of a button

Boycee

Board Regular
Joined
Nov 23, 2002
Messages
109
I have a formula in cell L23 =SUM(D15*E20+E22)

This will change total everytime one of the cells in the formula is altered.

What I would like to do is for the formula to only calculate the total at a press of a button.

So if D15 was change the total would remain the same until the button (linked to a macro) was pressed and then L23 would show the new correct total.

Can anyone help, is this possible.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Use this as code and asign a button to it.

Code:
Sub xxx()
Range("L23") = Range("D15") * Range("E20") + Range("E22")
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,140
Messages
5,570,400
Members
412,321
Latest member
Yusuf_A
Top