Make cells flash.
 

I need to know the ste-by-step process on how to make cells flash.


--
aacstv
------------------------------------------------------------------------
aacstv's Profile: http://www.excelforum.com/member.php...o&userid=33440
View this thread: http://www.excelforum.com/showthread...hreadid=532529

Make cells flash.
 

http://www.cpearson.com/excel/newposte.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"aacstv" wrote in
message ...

I need to know the ste-by-step process on how to make cells flash.


--
aacstv
------------------------------------------------------------------------
aacstv's Profile:
http://www.excelforum.com/member.php...o&userid=33440
View this thread: http://www.excelforum.com/showthread...hreadid=532529

Make cells flash.
 

Here's one version

Sub cell_animation()
again1:
Dim w As Worksheet
Set w = Worksheets("sheet1")
Randomize
n = 67
m = 5
w.Range(Chr(n) & m).Rows.Interior.Color = QBColor(Int((Rnd * 5) + 1))
DoEvents
Application.Wait (Now + 1 / 24 / 60 / 120 / 0.9)
'TimeValue("0:00:01"))
GoTo again1:
End Sub

HTH
Michael

"aacstv" wrote:


I need to know the ste-by-step process on how to make cells flash.


--
aacstv
------------------------------------------------------------------------
aacstv's Profile: http://www.excelforum.com/member.php...o&userid=33440
View this thread: http://www.excelforum.com/showthread...hreadid=532529