How do I get text to permanently flash?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2000. Need text to flash at all times for a display screen. Has to be
excel as several calculations also required
 
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
 
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
 
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
 
You must log in or register to reply here.

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

how do i make a word flash or blink in excel 1
Printer Problem... Epson Stylus Photo R200 4
Excel 2007 text flash (or blink) 4
How do I enable text to flash on and off? 3
Canon IP 6600D Photo Printer 2
How do I make flashing words in excel 1
Bold rectangle cursor in VB Editor 3
How do I flash text in Excel 1

Back
Top