Excel programming question

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?

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

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 :eek:

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.