Is it possible to have in a cell a character that blinks ?
 

Jeanmi
One can make blink a cell, but is it possible to have a
character in a word in a cell that blinks (with Characters ?) ...

Thank you in advance,

Jean-michel

*** Sent via Developersdex http://www.developersdex.com ***

Is it possible to have in a cell a character that blinks ?
 

Hi Jean-Michel,

See Chip Pearson at:

Blinking Text In Excel
http://www.cpearson.com/excel/BlinkingText.htm

Use Chip's suggested code but try replacing Chip's
StartBlink procedure with the following adaptation:

'=============
PublicSub StartBlink()

With Range("A1").Characters(2, 1).Font
If .ColorIndex = xlAutomatic Then
.ColorIndex = 3
Else
.ColorIndex = xlAutomatic
End If
End With

RunWhen = Now + TimeSerial(0, 0, 1)
Application.OnTime RunWhen, "StartBlink", , True
End Sub
'<<=============


---
Regards,
Norman


"Jack clav" wrote in message
...


Jeanmi
One can make blink a cell, but is it possible to have a
character in a word in a cell that blinks (with Characters ?) ...

Thank you in advance,

Jean-michel

*** Sent via Developersdex http://www.developersdex.com ***

Is it possible to have in a cell a character that blinks ?
 

here's one way:

Sub Blink()
With Range("A1")
If Len(.Text) 0 Then
With .Characters(Start:=1, Length:=1).Font
.ColorIndex = IIf(.ColorIndex = 7, xlColorIndexAutomatic, 7)
End With
End If
End With
Application.OnTime Now + TimeSerial(0, 0, 1), "Blink", , True
End Sub

Put some text in A1 and then run the procedure.. it will make the first
character in A1 blink.


--
Hope that helps.

Vergel Adriano


"Jack clav" wrote:



Jeanmi
One can make blink a cell, but is it possible to have a
character in a word in a cell that blinks (with Characters ?) ...

Thank you in advance,

Jean-michel

*** Sent via Developersdex http://www.developersdex.com ***