Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='cabratt' post='776300' date='21-May-2009 14:37']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![/quote]

    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:
    Attached Images Attached Images
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    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

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post
    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"

  5. #5
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='TonyE' post='776354' date='21-May-2009 23:50']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"[/quote]
    Thank you all for your help! I greatly appreciate it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •