PDA

View Full Version : Limited Blinking text



av8tordude
12-28-2011, 06:44 AM
How can I make a text blink only 5 times. Thank you for your assistance.

Aussiebear
12-28-2011, 11:15 PM
Try running it on a timer

macropod
12-29-2011, 01:22 AM
To 'flash' C3 five times, you could use code like:
Option Explicit
Dim i As Long
Sub FlashCell()
With Cells(3, 3).Borders
If .LineStyle = xlContinuous Then
.LineStyle = xlNone
Else
.Weight = xlMedium
.LineStyle = xlContinuous
End If
End With
i = i + 1
If i Mod 10 = 0 Then
i = 0
Exit Sub
End If
Application.OnTime Now + TimeValue("0:00:01"), "FlashCell"
End Sub

mdmackillop
12-29-2011, 11:11 AM
Does this (http://www.dailydoseofexcel.com/archives/2006/01/23/blinking-cells/) help?

Aussiebear
12-29-2011, 02:21 PM
The one common point in all of the discussions relating to "blinking text", is that those people generally held in high regard with Excel and or VBA all suggest not using blinking text where possible.

macropod
12-29-2011, 02:58 PM
The one common point in all of the discussions relating to "blinking text", is that those people generally held in high regard with Excel and or VBA all suggest not using blinking text where possible.Two good reasons for not using it:
1. It destroys Excel's undo function for anything prior; and
2. It's bad visually.

Aussiebear
12-30-2011, 02:05 AM
There you go