Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Help Needed - Blinking TEXT

Thanks for the reply.

I tried putting that code in as follows.
----------------------------------------------------------------------
Sub StartBlink()
If
Workbooks("DailyBalance").Sheets("Main").Range("Bl ink").Font.ColorIndex
= 2 Then

Workbooks("DailyBalance").Sheets("Main").Range("Bl ink").Font.ColorIndex
= xlColorIndexAutomatic
Else

Workbooks("DailyBalance").Sheets("Main").Range("Bl ink").Font.ColorIndex
= 2
End If
RunWhen = Now + TimeSerial(0, 0, 1)
Application.OnTime RunWhen, "StartBlink", , True
End Sub
---------------------------------------------------------------------

But when I re-open the file following error comes up.

"Subscript Out of range"

Any HELP?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Blinking Text Esra Dekan Excel Worksheet Functions 43 February 19th 08 12:42 AM
Blinking text if.... ewagz Excel Programming 1 January 24th 06 03:00 PM
blinking text lucas Excel Programming 5 October 31st 05 04:12 PM
Blinking Text Gordon C Excel Programming 1 December 7th 03 06:16 PM
Blinking Text? Wazza McG[_2_] Excel Programming 1 December 6th 03 09:59 PM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"