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!
|