How can I make a text blink only 5 times. Thank you for your assistance.
How can I make a text blink only 5 times. Thank you for your assistance.
Try running it on a timer
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
To 'flash' C3 five times, you could use code like:
[vba]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[/vba]
Cheers
Paul Edstein
[Fmr MS MVP - Word]
Does this help?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Two good reasons for not using it:Originally Posted by Aussiebear
1. It destroys Excel's undo function for anything prior; and
2. It's bad visually.
Cheers
Paul Edstein
[Fmr MS MVP - Word]
There you go
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
