Looping for a specific time

Solved/Closed
selflearner Posts 16 Registration date Wednesday 21 October 2009 Status Member Last seen 12 March 2010 - 7 Mar 2010 à 12:54
selflearner Posts 16 Registration date Wednesday 21 October 2009 Status Member Last seen 12 March 2010 - 9 Mar 2010 à 08:08
Hello,
I'm using Excel 2007

I have the following code:

Sub Macro1()
With Selection.Interior
.Color = 255
End With
Application.Wait Now + TimeValue("00:00:01")
With Selection.Interior
.Color = 15773696
End With
Application.Wait Now + TimeValue("00:00:01")
With Selection.Interior
.Color = 255
End With
End Sub

Is there a way to have the color changing last for two minutes without having to copy it 120 times ?
Mike
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
7 Mar 2010 à 14:47
selflearner Posts 16 Registration date Wednesday 21 October 2009 Status Member Last seen 12 March 2010
9 Mar 2010 à 08:08
Hello rizvisa1,
Thanks for the help. That's exactly what I needed

Mike