Pause sub

Rodrigo Mota · #1 (**permalink**) 12-13-04, 15:01

hi

Is there any way to pause a sub, so something else can be done in a excel sheet and then after some time or for example a sheet get focus to continue that sub

Thanks

DavidCoutts · #2 (**permalink**) 12-14-04, 03:18

For a length of time wait you can use

Application.OnTime

or to completly halt the macro just stop it, write a text command somewhere in your workbook so that the new event will run only when this happens

i.e.

Code:

'at end of your sub
    Worksheets("Sheet2").Range("A1").Value = "GO"
End Sub

'in sheet2
Private Sub Worksheet_Activate()
    If Not Range("A1").Value = "GO" Then Exit Sub
    MsgBox "Run Here"
End Sub

Dave

Rodrigo Mota · #3 (**permalink**) 12-14-04, 11:41

Thanks Dave

That was exactly what I was looking for

Cheers

Internet Services

Web Development

Digital Marketing

Consumer Tech