MrExcel Publishing
Your One Stop for Excel Tips & Solutions

flashing or blinking text


Posted by John Calder on August 07, 2001 4:17 PM

I am using an IF statement that contains a short message I would like to have flashing on the screen when it enables.

=IF(G5<50,"ORDER MORE STOCK","SUFFICIENT 20um FILTERS IN STOCK")

Can you help me achieve this ?

Thank you
John Calder


Posted by Connie on August 08, 2001 6:41 AM

John, I believe you'll need to start with a macro. See the following post for the code to make a cell flash. This may at least get you started. You can also search the archives on this forum because quite a few people have asked about flashing text in the past. You may find some other answers.
Connie

25472.html