Faux MsgBox as vbModeless

**MisterPan** · 11-27-2014, 01:09 PM

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

**6StringJazzer** · 11-27-2014, 01:45 PM

There is not a built-in one but you can make your own. In your VBA project, copy CustomMsgBox from this project--it's a form that will act as a modeless MsgBox with Retry and Cancel buttons. The comments in the code will tell you how to use it.