Quote Originally Posted by Doogle View Post
If I understand correctly, you wish to suspend execution until the user has performed some operation involving a file. Rather than use a command 'Next' why not just prompt the user for the information when it is required. Using a simple MsgBox (or InputBox or a CommonDialog) will suspend execution until the user responds.
e.g.
Code:
.. blah
.. blah
lngReturn = MsgBox("Please import the file now, then click OK to continue", vbOkCancel, "Waiting for User")
If lngReturn = vbOk Then
    .. blah
    .. blah
Else
   <user clicked Cancel>
End If
this does the job BUT the problem is that the user will have to move/hide this popup window while he imports the file(s) and check if all info is OK. then he will have to get back to the popuwindow and click OK to continue the process. it's possible to do the same thing without suspending the execution with a popup window?