delay then execute the next line

[Shodow]

what is the code to delay then execute the next line

[debasisdas]

Why you always keep asking for code ?

Show some effort .

[Pgmer]

You can go for threads where u can give some pause..
m i right debasis?

[Shodow]

i am done searching but no luck for me

[debasisdas]

All you luck is here.

[Vineeth K]

why don't you use a time pause function to delay or a timer ????

[Shodow]

how can i do that?

[debasisdas]

Try to go through the code.
Understand if you can.
Implement the way you want....

[Paul J S]

For a simple solution see below. I've used this for years:

1) Place a timer on a form.
Name it tmrWaiting
Set its interval property to 1000. (That’s 1 second)

2) Declare a form level Boolean variable. E.G. Dim waiting as Boolean

3) In the timer event. Just type:
waiting = false

4) On the line where the delay must be, type:

waiting = True
Print "Hello"
Do While waiting
DoEvents
Loop
Print "Bye"

Here’s an example. Just tyhe same really: ... Simples. Good luck. Paul

Option Explicit

Dim waiting As Boolean

Private Sub Form_Activate()
waiting = True
Print "Hello"
Do While waiting
DoEvents
Loop
Print "Bye"
End Sub

Private Sub tmwWaiting_Timer()
waiting = False
End Sub