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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

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,074
Messages
5,570,048
Members
412,308
Latest member
cornelb
Top