|
-
Jun 7th, 2013, 08:01 AM
#7
Thread Starter
Junior Member
Re: Loop until element exists, the continue execution
 Originally Posted by Doogle
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?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|