VBA Code to flash text

[Malcolm torishi]

Hello
does any one know if it possible to have text flash for say 15 seconds to tell the user of an error. I have an if statement in cell c2 with an error message and if the error messages appears I would like the message to flash for say 15 seconds. Thank you if any one can help

 

[Yongle]

How about a simple message box which forces user to acknowledge the error

Goes in SHEET module (does not work in standard module)

Private Sub Worksheet_Calculate()
    If [c2] = "Error message" Then MsgBox [c2]
End Sub

 

[Malcolm torishi]

How about a simple message box which forces user to acknowledge the error

Goes in SHEET module (does not work in standard module)

Private Sub Worksheet_Calculate()
    If [c2] = "Error message" Then MsgBox [c2]
End Sub

Thank you that sounds a better way