![]() |
Blinking text if....
Could you make a "if" formula that would use cpearson's blinking text code
when a cell's variable changed. For instance: a2=82% (no blinking); a2=78% (blink). What would such a formula look like that would have an "if" and have the "then" refer to a macro look like? Thanks in advance to all.... -- EW - Analyst |
Blinking text if....
Private Sub Worksheet_Calculate()
if Range("A2").Value < .80 then StartBlinkRoutine else StopBlinkRoutine end if End Sub -- Regards, Tom Ogilvy "ewagz" wrote in message ... Could you make a "if" formula that would use cpearson's blinking text code when a cell's variable changed. For instance: a2=82% (no blinking); a2=78% (blink). What would such a formula look like that would have an "if" and have the "then" refer to a macro look like? Thanks in advance to all.... -- EW - Analyst |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com