Please help: How to make a button to show the sum?
 

hi,

In my excel, I would like to make a button which could show the sum o
certain cells, say, E3 to E6, after pressing it. I am wondering if i
is made by VBA? If yes, how?

I would very much appreciate your help if you could help me figure ou
this problem

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

Please help: How to make a button to show the sum?
 

If you select two or more cells that contain numbers, you can see the
sum in the status bar, at the bottom right of the Excel window.

Right-click on the AutoCalculate area of the status bar, and you can
choose from a list of summary functions.

raymondinuk < wrote:
hi,

In my excel, I would like to make a button which could show the sum of
certain cells, say, E3 to E6, after pressing it. I am wondering if it
is made by VBA? If yes, how?

I would very much appreciate your help if you could help me figure out
this problem.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Please help: How to make a button to show the sum?
 

Dear Debra,

Thank you for your prompt answer. I have learned another skill fro
your answer but I am afraid I didn't make my problem clear.

What I want to do is to put a button on the worksheet name
"calculate". After pressing this button, I want a dialogue box to po
up and show the sume of certain cells. I think this may need VBA o
macro but I don't know how to figure it out. Need your help again.

Many thanks.

Debra Dalgleish wrote:
*If you select two or more cells that contain numbers, you can se
the
sum in the status bar, at the bottom right of the Excel window.

Right-click on the AutoCalculate area of the status bar, and you can
choose from a list of summary functions.
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Please help: How to make a button to show the sum?
 

You could use a macro like this:

Sub SumCells()
MsgBox WorksheetFunction.Sum(Range("E3:E6"))
End Sub

raymondinuk < wrote:
Dear Debra,

Thank you for your prompt answer. I have learned another skill from
your answer but I am afraid I didn't make my problem clear.

What I want to do is to put a button on the worksheet named
"calculate". After pressing this button, I want a dialogue box to pop
up and show the sume of certain cells. I think this may need VBA or
macro but I don't know how to figure it out. Need your help again.

Many thanks.

Debra Dalgleish wrote:

*If you select two or more cells that contain numbers, you can see
the
sum in the status bar, at the bottom right of the Excel window.

Right-click on the AutoCalculate area of the status bar, and you can
choose from a list of summary functions.
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html *



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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Please help: How to make a button to show the sum?
 

Thank you very much, Debra

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

Please help: How to make a button to show the sum?
 

raymond

Alternate with non hard-coded selection.

Sub Sum_Range()
Set rng = Selection
MsgBox WorksheetFunction.Sum(rng)
End Sub

Gord Dibben Excel MVP

On Tue, 25 May 2004 08:39:54 -0500, raymondinuk
wrote:

Thank you very much, Debra.


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