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

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

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

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

Thank you very much, Debra

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

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/