Creating a Pop-up Summary Box with Data
 

Is it possible to create a pop-up or dialog box that can tell you the
sum of two cells? The values in the two cells will keep changing, but
I want the sum to pop up so it is easy to see. Thanks!

Creating a Pop-up Summary Box with Data
 

sure! example:

Sub msgbox_sum()

Dim numberone As Range
Dim numbertwo As Range
Dim ws As Worksheet

Set ws = ActiveSheet
Set numberone = ws.Range("b3")
Set numbertwo = ws.Range("b6")

MsgBox numberone + numbertwo


End Sub

change ranges to meet your needs.
susan



On Mar 2, 4:01 pm, wrote:
Is it possible to create a pop-up or dialog box that can tell you the
sum of two cells? The values in the two cells will keep changing, but
I want the sum to pop up so it is easy to see. Thanks!

Creating a Pop-up Summary Box with Data
 

I'm sorry, I don't know much about visual basic. How can I get the
pop up display to say, "The total is" and then show the number? Is it
also possible to change the ranges so that one value might be on one
sheet, whereas the other value is on another?

Thank you very much!

On Mar 2, 3:08 pm, "Susan" wrote:
sure! example:

Sub msgbox_sum()

Dim numberone As Range
Dim numbertwo As Range
Dim ws As Worksheet

Set ws = ActiveSheet
Set numberone = ws.Range("b3")
Set numbertwo = ws.Range("b6")

MsgBox numberone + numbertwo
I End Sub


change ranges to meet your needs.
susan

On Mar 2, 4:01 pm, wrote:



Is it possible to create a pop-up or dialog box that can tell you the
sum of two cells? The values in the two cells will keep changing, but
I want the sum to pop up so it is easy to see. Thanks!- Hide quoted text -

- Show quoted text -

Creating a Pop-up Summary Box with Data
 

Select the two cells then right-click on the status bar and "Sum"

Or in a third cell enter =cell1 + cell2

A pop-up message would require VBA

Sub Sum_Range()
Set rng = Selection
MsgBox "The Sum is " & WorksheetFunction.Sum(rng)
End Sub


Gord Dibben MS Excel MVP


On 2 Mar 2007 13:01:40 -0800, wrote:

Is it possible to create a pop-up or dialog box that can tell you the
sum of two cells? The values in the two cells will keep changing, but
I want the sum to pop up so it is easy to see. Thanks!

Creating a Pop-up Summary Box with Data
 

If you select two numeric cells, in the lower right corner of excel, you
should see the sum. It works for all cells selected.

Use the built in capabilities of the software.

--
Regards,
Tom Ogilvy





" wrote:

Is it possible to create a pop-up or dialog box that can tell you the
sum of two cells? The values in the two cells will keep changing, but
I want the sum to pop up so it is easy to see. Thanks!