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!

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, radhikac...@gmail.com 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!

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" <bogenex...@aol.com> 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, radhikac...@gmail.com 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 -

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, (E-Mail Removed) 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!

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





"(E-Mail Removed)" 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!
>
>