Delay Macro

[help000]

I am trying to delay a Macro code (I went into Edit and it opened up in Visual Basic), I am trying to delay it for a second, any thoughts. Timer=Timer+1 is my best guess but It's not working.

Thanks in advance

Mike

[VBA Noob]

Try something like

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

[johnske]

In a standard module...

Please Login or Register  to view this content.

When you need the delay in another procedure just use Pause 1 (or any other number that suits)