Previous Topic Next Topic

Looping for a specific time

Solved/Closed
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010 - Mar 7, 2010 at 12:54 PM
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010 - Mar 9, 2010 at 08:08 AM
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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 7, 2010 at 02:47 PM
See this thread

https://ccm.net/forum/affich-66700-excel-make-cell-flash-red
1
selflearner Posts 16 Registration date Wednesday October 21, 2009 Status Member Last seen March 12, 2010
Mar 9, 2010 at 08:08 AM
Hello rizvisa1,
Thanks for the help. That's exactly what I needed

Mike
0

Similar discussions

The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
Facebook
Kasonde -
ElenaKM -

1 response
Keyboard wont type any letter twice
zsal5718 -
manoj -

23 responses