Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Flashing Cells
Hi everybody, I have a code that makes a specific cell blinking .. it works very well, but with one cell only .. I tried to develop it to be active with more than one cell, but I could not. This is the code and I wish I could find the answer he Public Sub Blink() With Sheets(1).Range("A1").Interior If .ColorIndex = 2 Then ..ColorIndex = 3 Else ..ColorIndex = 2 End If End With appTime = Now() + TimeValue("00:00:01") Application.OnTime appTime, "Blink" End Sub Thank you, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=401858 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flashing cells | Excel Worksheet Functions | |||
flashing cells | Excel Worksheet Functions | |||
Flashing cells | Excel Worksheet Functions | |||
Flashing cells | Excel Discussion (Misc queries) | |||
flashing cells | Excel Discussion (Misc queries) |