Excel 2002 and 2007

Topic

New Reply

I have a client who sent me an inquiry and I don’t have an answer. The inquiry is: I have a spreadsheet with multiple sheets. As I go from sheet to sheet, I want the value of one particular cell, on my front sheet to be displayed in the status bar and I can watch it re-calculate as I make changes in the other sheets. Is this possible? I have seen it before, but do not know how they did it. Client now advises that he is using Excel on a Mac.

Can anyone help me with this? Thanks in advance for any input!

Reply | Quote

Replies

I have a client who sent me an inquiry and I don’t have an answer. The inquiry is: I have a spreadsheet with multiple sheets. As I go from sheet to sheet, I want the value of one particular cell, on my front sheet to be displayed in the status bar and I can watch it re-calculate as I make changes in the other sheets. Is this possible? I have seen it before, but do not know how they did it. Client now advises that he is using Excel on a Mac.

Can anyone help me with this? Thanks in advance for any input!

Don’t know about the status bar but I show my students how they can take a picture link of a cell and tote the picture link anywhere they want to…when the cell changes it shows the change in the picture link. You can do one of two things.

(1)
You can use the Paste Picture link command after copying the cell of interest, or

(2) looking thru your “Commands Not on the Ribbon options in Excel Options…locate the “Camera” tool and add it to the QAT so it will be readily available to take a snapshot of any cell/cells you would like to keep an eye on.

See pics included:

Reply | Quote

You can add this code in the “Thisworkbook” module of the workbook and whenever the workbook recalculates it will put the contents of Sheet1 cell A1 (changes as desired) in the statusbar

Code:

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
  Application.StatusBar = Worksheets("Sheet1").Range("A1").Value
End Sub

Steve

Reply | Quote

Another method of doing this is to use the watch window. For details on using it in Excel 2007 see Watch a formula and its result by using the Watch Window – Microsoft Office Online

In Excel 2002 you can access the watch window via “View | Toolbars | Watch Window”

Reply | Quote

Another method of doing this is to use the watch window. For details on using it in Excel 2007 see Watch a formula and its result by using the Watch Window – Microsoft Office Online

In Excel 2002 you can access the watch window via “View | Toolbars | Watch Window”

Thank you all for your help! I greatly appreciate it.

Reply | Quote