pausing a macro for user to have a look

[RET79]

Hi.

It would sometimes be useful if a big macro I had could have some sort of 'timeout' thing so that the user could check hwo things are going mid-macro and stop it before it makes a complete hash of things.

How would you suggest doing this.

It would be handy to get the user to, after inspecting what the macro has done, have a choice of 2 buttons - OK to continue and cancel to abort macro.

Any suggestions welcomed.

thanks,

RET79

[Ivan F Moala]

On 2002-04-27 15:52, RET79 wrote:
Hi.

It would sometimes be useful if a big macro I had could have some sort of 'timeout' thing so that the user could check hwo things are going mid-macro and stop it before it makes a complete hash of things.

How would you suggest doing this.

It would be handy to get the user to, after inspecting what the macro has done, have a choice of 2 buttons - OK to continue and cancel to abort macro.

Any suggestions welcomed.

thanks,

RET79

Easiest way is to use the Application.Inputbox method
This Function has OK & cancel
Just assign these keys to some routine.

[Ivan F Moala]

Heres an example of what I mean.

Sub Paused()

Dim YC As Variant



On Error Resume Next

YC = Application.InputBox("Please check the sheets", "Paused for checking")

If YC = False Then

    '// User cancelled!

    MsgBox "Cancelled"

Else

    '// User selected OK

    MsgBox YC & " User pressed OK"

End If

On Error GoTo 0



End Sub

[RET79]

Ivan, that's perfect.

Thanks so much,

RET79