Blinking text if....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ewagz - 24 Jan 2006 14:45 GMT

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....

Signature

EW - Analyst

Reply to this Message

Tom Ogilvy - 24 Jan 2006 15:00 GMT

Private Sub Worksheet_Calculate()
if Range("A2").Value < .80 then
StartBlinkRoutine
else
StopBlinkRoutine
end if
End Sub

Signature

Regards,
Tom Ogilvy

> 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....

Reply to this Message