Hello,
I am trying to produce a 1 second delay function using "Wait":

Function Delay ( Input )

Application.Wait ( TimeValue "00:00:01")

Delay = Input

End Function


One, I must be doing something wrong because the delay is not produced
for any delay time specified (even 30 seconds). Please, what should I
improve?

Two, I don't want to suspend other activities in the worksheet when the
delay is executed. Will "Wait" be appropriate for that purpose? What
are the alternatives?

Thank you very much for your time.
Steve