flashing text in Excel

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)

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


"John Davies" <JohnDavies@discussions.microsoft.com> wrote in message news:6FF93268-9711-4A78-9E6B-BA8DE785FEBA@microsoft.com...
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)

No built in support for it.

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


--
Regards,
Tom Ogilvy

"John Davies" <JohnDavies@discussions.microsoft.com> wrote in message
news:6FF93268-9711-4A78-9E6B-BA8DE785FEBA@microsoft.com...
> 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)

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


"John Davies" <JohnDavies@discussions.microsoft.com> wrote in message
news:6FF93268-9711-4A78-9E6B-BA8DE785FEBA@microsoft.com...
> 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)

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. ;->)


----
Nick Hebb
BreezeTree Software
http://www.breezetree.com

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

"Nick Hebb" <n.hebb@comcast.net> wrote in message
news:1127783096.755456.47060@g49g2000cwa.googlegroups.com...
> 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. ;->)
>
>
> ----
> Nick Hebb
> BreezeTree Software
> http://www.breezetree.com
>

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


"John Davies" <JohnDavies@discussions.microsoft.com> wrote in message news:6FF93268-9711-4A78-9E6B-BA8DE785FEBA@microsoft.com...
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)

Hi Richard,

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

---
Regards,
Norman



"R. Choate" <rchoatecpa@NoSpam.com> wrote in message
news:%23c241w5wFHA.2348@TK2MSFTNGP15.phx.gbl...
> This user hasn't responded to anything since his OP. I don't think he is
> even reading this stuff.
> --
> RMC,CPA
>
>
> "John Davies" <JohnDavies@discussions.microsoft.com> wrote in message
> news:6FF93268-9711-4A78-9E6B-BA8DE785FEBA@microsoft.com...
> 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)
>
>

> 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!

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

----
Nick Hebb
BreezeTree Software
http://www.breezetree.com

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!

---
Regards,
Norman



"Nick Hebb" <n.hebb@comcast.net> wrote in message
news:1127857711.378032.69810@g43g2000cwa.googlegroups.com...
> Agh, Norman, you beat me to the punch! <g>
>
> ----
> Nick Hebb
> BreezeTree Software
> http://www.breezetree.com
>

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


"Norman Jones" <normanjones@whereforartthou.com> wrote in message news:uPQG6r6wFHA.1276@tk2msftngp13.phx.gbl...
Hi Richard,

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

---
Regards,
Norman



"R. Choate" <rchoatecpa@NoSpam.com> wrote in message
news:%23c241w5wFHA.2348@TK2MSFTNGP15.phx.gbl...
> This user hasn't responded to anything since his OP. I don't think he is
> even reading this stuff.
> --
> RMC,CPA
>
>
> "John Davies" <JohnDavies@discussions.microsoft.com> wrote in message
> news:6FF93268-9711-4A78-9E6B-BA8DE785FEBA@microsoft.com...
> 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)
>
>