Blinking text if....

G

Guest

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

Tom Ogilvy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top