Blinking Text?

G

GK

I'm trying to find a way (without using VBA) of formatting a cell in such a way that it flashes or does other groovy things.

In Word XP there are special text effects which include blinking. fading in/out etc.........


I'm running Excel XP
Does anyone know of an add-in or other simple way of doing this OR getting other extra formats
 
B

Biff

Sorry, can't be done!
-----Original Message-----
I'm trying to find a way (without using VBA) of
Click to expand...
formatting a cell in such a way that it flashes or does
other groovy things.
In Word XP there are special text effects which include
Click to expand...
blinking. fading in/out etc.........
I'm running Excel XP
Does anyone know of an add-in or other simple way of
Click to expand...
doing this OR getting other extra formats
 
R

Ron de Bruin

There is a way if you really want
here is an example that Bill Manville posted


The following code will blink any cells that have the style Blink
(create a new style using Format / Style). Format the cell concerned
with style Blink and then run macro Flash to initiate the process.
Since the cell is blank if not showing ERROR you will not see the
blinking unless ERROR is displayed.

Dim NextTime As Date

Sub Flash()
NextTime = Now + TimeValue("00:00:01")
With ActiveWorkbook.Styles("Blink").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("Blink").Font.ColorIndex = xlAutomatic
End Sub
 
M

Myrna Larson

Except that he said he doesn't want to use VBA. Without VBA, this isn't possible, right?
 
Top