How do I get text to permanently flash?

G

garym

Excel 2000. Need text to flash at all times for a display screen. Has to be
excel as several calculations also required
 
E

eluehmann

I owuld love to know this to... the only thing I can think of is som
kind of loop in VB that deletes and reenters teh text over and over..
I know there must be an easier way though :confused
 
S

ste mac

Hi garym, use this and flash away...
Apologies if you know...
"Cells(7, 5)" is the cell address, just copy for as many flashes as
you want....

Public Sub flashalot()
ActiveSheet.Cells(7, 5) = " Text to flash"
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(7, 5) = ""
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(7, 5) = " Text to flash"
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(7, 5) = ""
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(7, 5) = " Text to flash"
Application.Wait (Now + TimeValue("0:00:01"))
ActiveSheet.Cells(7, 5) = ""

End Sub

seeya ste
 
G

Gord Dibben

The only way to get blinking cells is to use VBA code.

Nothing else can be done while the code is running so "calculations" would
seem to be out of the question.

But........if you're determined see google search results for "blinking cells"

http://snipurl.com/9e6w

Gord Dibben Excel MVP
 
Top