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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

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,112,885
Messages
5,543,028
Members
410,583
Latest member
gazz57
Top