Excel programming question

[JewishIntent]

I am trying to write an auto_start macro for an excel workbook. I have very little programming experience, took a true basic class back in '98, and was looking for a little help or direction. All i need is the command to pause execution. I think i remember in true basic it was litterally just

Pause 4

and the execution of code would hold for 4 sec. What is the command to do something like this in visual basic, which is the language used in excel?

[SirDice]

IIRC Office uses VBA (Visual Basic for Applications) since 98 (not sure about the version). Before that it used a macro language..

These may help:
http://msdn.microsoft.com/office/dow...a/default.aspx
http://www.mindspring.com/~tflynn/excelvba.html

[nihil]

IIRC you insert a line in your macro like this:

Application.Wait Now + TimeValue("00:00:04")

But it has been a long time since I have used it

[JewishIntent]

Thanks nihil that was exactly what i needed, and the syntax is correct. i just coppied and pasted it into my macro and it works, i did change the delay to 2 sec but that doesn't really matter.