Add a label to the Ribbon in Excel to display a changing total

Hi All
I am using Excel 2010. What I want to do is the following in an Excel workbook I have numerous worksheets. In one of the sheets (Sheet1) I have a pivot table that with a total in it that I currently display in a floating user form when I’m working on sheets2 to sheetX. Since the total will change depending on what is done in the other sheets is necessary to view this total the whole time to monitor any changes and to see if the change will be acceptable. Is there a way to add a Label or something similar to the ribbon to display this total?
Thanks in advance
Elmo
LVL 1
cErasmusAsked:
Who is Participating?
 
SteveCommented:
to change the ribbon is quite involved...

It may be simpler to use the Statusbar

For this to work a little bit of code on the workbook calculate event would do the job:
See example workbook attached...
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)

Dim ChangingValue As String
ChangingValue = CStr(Sheets("Sheet1").Range("A1").Value)
Application.StatusBar = "the value in A1 = " & ChangingValue

End Sub

Open in new window

Statusbar.xlsm
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you could open a new window (View > New Window), then arrange the windows, so the window with the summary is visible next to the window where you flick from sheet to sheet.

cheers, teylyn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.