Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating regional summary data | Excel Discussion (Misc queries) | |||
creating a summary from a data dump | Excel Programming | |||
Creating a summary list from source data - can you?? | Excel Discussion (Misc queries) | |||
Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions | |||
Creating a summary from existing spreadsheet data ... | Excel Programming |