flashing text in Excel

[Guest]

Is it possible to have flashing text in Excel?
Say Cell A3 = 1 - Cell A4 = "Correct" (Flashing Blue Text)
Cell A3 = 2 - Cell A4 = "Incorrect" (Flashing Red Text"
Cell A3 = 3 - Cell A4 = "Try Again" (Non Flashing)

 

[R. Choate]

You could write code to change the font color back and forth between white and whatever on a timer. Would that solve your problem?

--
RMC,CPA


Is it possible to have flashing text in Excel?
Say Cell A3 = 1 - Cell A4 = "Correct" (Flashing Blue Text)
Cell A3 = 2 - Cell A4 = "Incorrect" (Flashing Red Text"
Cell A3 = 3 - Cell A4 = "Try Again" (Non Flashing)

 

[Tom Ogilvy]

No built in support for it.

obviously you could cobble something together in VBE, but you would suck up
a lot of resources.

 

[Robin Hammond]

John,

Here's an approach you could adapt to your needs that I put together in
response to a question about making a range flash a few weeks ago.

However, I think you might genuinely be better off using conditional
formatting for your font colours and forget about the flashing.

Robin Hammond
www.enhanceddatasystems.com

Private appTime As Double
Private rngSaved As Range
Private bStop As Boolean

Sub Test()
InitBlinking ActiveSheet.Range("a1:d5")
End Sub

Sub InitBlinking(rngBlink As Range)
Set rngSaved = rngBlink
bStop = False
Blink
End Sub

Sub StopBlinking()
bStop = True
End Sub

Public Sub Blink()
Dim rngCell As Range
For Each rngCell In rngSaved
With rngCell
If bStop Then
.Interior.ColorIndex = 2
Else
.Interior.ColorIndex = IIf(.Interior.ColorIndex = 2, 3, 2)
End If
End With
Next rngCell
If Not bStop Then
appTime = Now() + TimeValue("00:00:01")
Application.OnTime appTime, "Blink"
End If
End Sub

 

[Nick Hebb]

Do you really need the text to flash? That's really annoying to users.
Why not just change the text to bold red, or white with a red
background?

Also, it's well documented that flashing text can induce seizures -
especially in epileptics. (I'm not making this up, but I'm too lazy to
search for a reliable source. ;->)

 

[NickHK]

Nick,
I have read about the seizures aspects also.
I'm not epileptic, but would find flashing cell incredibly annoying,
especially if I did not know the cause and what I was supposed to do about
it.

To the OP, if the point is that important that the user MUST react, give
them a msgbox or similar with instructions.

NickHK

 

[R. Choate]

This user hasn't responded to anything since his OP. I don't think he is even reading this stuff.
--
RMC,CPA


Is it possible to have flashing text in Excel?
Say Cell A3 = 1 - Cell A4 = "Correct" (Flashing Blue Text)
Cell A3 = 2 - Cell A4 = "Incorrect" (Flashing Red Text"
Cell A3 = 3 - Cell A4 = "Try Again" (Non Flashing)

 

[Norman Jones]

Hi Richard,

Maybe he has had a bad reaction to the flashing?!

 

[Nick Hebb]

This user hasn't responded to anything since his OP. I don't think he is even reading this stuff.

He probably figured out how do it own his own then promptly went into
seizure. Doh!

 

[Nick Hebb]

Agh, Norman, you beat me to the punch! <g>

 

[Norman Jones]

Hi Nick,

But I had an advantage - I had my eyes shut!

And, to forestall the obvious rejoinder, yes that explains much about my
coding style!

 

[R. Choate]

Hi Norman,

Hope all is well with you. I see you are still helping the masses. If you get time, please read my post about importing external
data. I've got an issue that is driving me crazy and I don't think my responders have a full grip on the real issues involved. I'll
bet you would be able to tell me what to do. If you get a chance, I posted it last night. There were several replies and
discussions, but nothing that really gets to the heart of the matter.

In any event, I'm sure we'll visit soon on something. You take care.

Richard
--
RMC,CPA


Hi Richard,

Maybe he has had a bad reaction to the flashing?!