[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2012-08-14
Medium Priority
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

Steve earned 2000 total points
ID: 38291320
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
ID: 38291370

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

872 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