View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default 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!