Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
How to output text that blinks? | Excel Discussion (Misc queries) | |||
program blinks and I lose 3-4 hours of work, autosave set 10 minut | Excel Discussion (Misc queries) | |||
Comment flashes (blinks) | Excel Discussion (Misc queries) | |||
Active cell blinks for no reason while running inside of Citrix XP | Excel Worksheet Functions |