Flashing Text

E

ExcelMonkey

Is it possible to make text flash within cells? I mean only the tex
itself, not the cell fill color
 
H

Hank Scorpio

Is it possible to make text flash within cells? I mean only the text
itself, not the cell fill color.
Click to expand...

No, thank the gods. At least not up until XL2002; I haven't tried 2003
yet, but I hope that that's not a new "feature" in that version. The
effects in Word are quite painful enough.

(Technically you COULD do it using VBA, but you'd have to have the
procedure running constantly which would mean that you couldn't do
anything else with the sheet.)
 
N

Norman Harker

Hi Hank!

You and many others will be relieved to know that blinking text was
not one of the new features in Excel 2003.

And welcome back!


Hi ExcelMonkey!

Here's one posting you could go to:

http://tinyurl.com/2mhey

But if anyone asks, don't tell them I helped you.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
R

Rocky McKinley

Yes there is a way however the user would have to wait while the flashing
routine runs. This flashes the Text in Range A1.

Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Sub FlashText()
Dim Cnt As Byte, FontColor, Rng As Range
Set Rng = Range("A1")
FontColor = Rng.Font.Color
For Cnt = 1 To 3
Rng.Font.Color = Rng.Interior.Color
Sleep 300
Rng.Font.Color = FontColor
Sleep 300
Next Cnt
End Sub
 
H

Hank Scorpio

Hi Hank!

You and many others will be relieved to know that blinking text was
not one of the new features in Excel 2003.
Whew...

And welcome back!
Click to expand...

Aw gee, thanks. I could never REALLY leave you guys... 8^>
 
E

ExcelMonkey

From what I can see, you have set up a For Next Loop and then controlled
its looping speed with the "Sleep 300". It looks as thought you have
an API call as well. Can you explain in detail what is happening
here?

P.S. It works great!
 
Top