Visual Popup when formula recalculates

[iansilv]

I have something I am doing for a charity auction- I have two computer displays, and I want each one to have an excel spreadsheet on it. One will be where I update the auction bids, the other will be where the formulas calculate the amounts.

Is it possible for the amounts to "popout" for a second when the values re-click? Or maybe change to bold for a second?

 

[GettingThere]

Hi,

Is it possible for the amounts to "popout" for a second when the values re-click? Or maybe change to bold for a second?

Is is just one figure in a specified cell that you want to 'pop out'?? Or will there be several figure that you want to popout only if they change??

The first is no problem - do you know how to insert code into the 'this workbook' module in VB? If so - insert this:

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
    
    Range("a1").Interior.ColorIndex = 44
    Range("a1").Font.Bold = True
    Application.Wait (Now + TimeValue("0:00:1"))
    Range("a1").Interior.ColorIndex = 0
    Range("a1").Font.Bold = False

End Sub

This will make cell A1 bold and go an amber colour for one second and then go back to no colour and not bold...

Pleease note this will trigger every time the sheet recalculates, whether or not the value of that cell changes.

Hope that's what you're after - if not give me a shout =D


A.