Flashing sentence

N

nona

Does anybody know whether its possible to let a sentence or word flash
in Excel, just like in Word or not? If so, how can this be done?
 
M

Max

Here's a recent relevant reply dug up via Google search...
----------------------------------------------
From: Bernie Deitrick ([email protected])
Subject: Re: to blink contents in a cell
View: Complete Thread (6 articles)
Original Format
Newsgroups: microsoft.public.excel.newusers
Date: 2003-11-07 10:52:24 PST

Bill Manville has developed a procedure to produce blinking text.

Code and instructions are below.

HTH,
Bernie
MS Excel MVP

'VBA CODE EXAMPLES
'
'Created by Bill Manville
'
'To create a blinking cell:
'
'If you define a new Style (Format / Style / Flash/ Add ) and apply
'that style to the cells you want to flash, paste the following code
'into a module sheet and run the procedure Flash from Auto-Open if
'desired you will get the text flashing alternately white and red.

Dim NextTime As Date

Sub Flash()
NextTime = Now + TimeValue("00:00:01")
With ActiveWorkbook.Styles("Flash").Font
If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
End With
Application.OnTime NextTime, "Flash"
End Sub

Sub StopIt()
Application.OnTime NextTime, "Flash", schedule:=False
ActiveWorkbook.Styles("Flash").Font.ColorIndex = xlAutomatic
End Sub

lakshmi said:
I want to make the contents in a cell to blink for seeking attention
Click to expand...
----------------------------------------


hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com for email
--------------------------------------------------
 
P

Peo Sjoblom

Just out of curiosity, is there anyone in this forum, who if they received a
spreadsheet with blinking
text that wouldn't try to turn it off? I can't imagine anything more
irritating than something like that (maybe sounds as well)
It makes for a fun example when having a class maybe but working with it,
Yikes!

--

Regards,

Peo Sjoblom


Max said:
Here's a recent relevant reply dug up via Google search...
----------------------------------------------
From: Bernie Deitrick ([email protected])
Subject: Re: to blink contents in a cell
View: Complete Thread (6 articles)
Original Format
Newsgroups: microsoft.public.excel.newusers
Date: 2003-11-07 10:52:24 PST

Bill Manville has developed a procedure to produce blinking text.

Code and instructions are below.

HTH,
Bernie
MS Excel MVP

'VBA CODE EXAMPLES
'
'Created by Bill Manville
'
'To create a blinking cell:
'
'If you define a new Style (Format / Style / Flash/ Add ) and apply
'that style to the cells you want to flash, paste the following code
'into a module sheet and run the procedure Flash from Auto-Open if
'desired you will get the text flashing alternately white and red.

Dim NextTime As Date

Sub Flash()
NextTime = Now + TimeValue("00:00:01")
With ActiveWorkbook.Styles("Flash").Font
If .ColorIndex = 2 Then .ColorIndex = 3 Else .ColorIndex = 2
End With
Application.OnTime NextTime, "Flash"
End Sub

Sub StopIt()
Application.OnTime NextTime, "Flash", schedule:=False
ActiveWorkbook.Styles("Flash").Font.ColorIndex = xlAutomatic
End Sub

lakshmi said:
I want to make the contents in a cell to blink for seeking attention
Click to expand...
----------------------------------------


hth
Max
-----------------------------------------
Please reply in newsgroup

Use xdemechanik
<at>yahoo<dot>com for email
--------------------------------------------------
Click to expand...
 
M

Max

well, it all depends what the blinking text is all about <g>

but perhaps the novelty would wear-off soon enough, i guess..
then it'll become an irritation to turn-off, as you said...

cheers
Max
 
T

Tushar Mehta

For a solution that doesn't require changes to code to change
formatting or to add multiple dynamic effects without changes to code
see http://www.tmehta.com/tmxl/dbfind_byid.asp?id=14

It does use a code module -- to create a one second beat. Then, with
conditional formatting, one can create all kinds of effects -- good,
bad, and ugly.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
T

Tushar Mehta

Maybe, that is the intent -- to be irritating. One way to ensure that
someone looks at an inconsistency or a logic error?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top