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

Posted on 2012-08-14
Last Modified: 2012-08-20
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
Question by:cErasmus
    LVL 24

    Accepted Solution

    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

    LVL 50

    Expert Comment


    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now