ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Blinking text if.... (https://www.excelbanter.com/excel-programming/351312-blinking-text-if.html)

ewagz

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

Tom Ogilvy

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