Flashing sentence

  • Thread starter Thread starter nona
  • Start date Start date
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?
 
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
--------------------------------------------------
 
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...
 
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
 
Peo Sjoblom said:
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)
Click to expand...
....

Agreed, but it leads to a philosophical tangent: why don't all the apps in
Office provide the same formatting capabilities? Why should text only be
able to flash in Word? Why can't input forms in Access be littered with
flashing prompts? Or, more crudely, why can't everything look like
PowerPoint?

Since it requires a option setting in Word to enable text animation, there
must be a subsystem separate from core Word functionality that provides this
functionality. Odd that Excel can't be adapted to use it. Or maybe the Excel
programmers just aren't as good as the Word programmers. Who knows?
 
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
 
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
 
Back
Top