Hi all,
Another little question for you all:
This time I've got a MsgBox which appears if a file can't be found. What I'd ideally like to happen is that the user (upon receiving the MsgBox) will then switch to another app, export the data to Excel, save in aforementioned location then hit "Retry" on the MsgBox to get the macro to check again. Assuming the file is there, I want the macro to continue going through the code.
I'm aware that the standard MsgBox is vbModal and cannot be changed from that state.
Is there another function I could use instead of MsgBox which will allow the user to interact with Excel whilst the macro is waiting for either the "Retry" or "Cancel" response?
Many thanks as always,
Peter
Bookmarks