Msgbox Question??

[VBAmateur]

Hey again, When the user clicks on save and is waiting for the function to finish (waiting for it to save) I want a msgbox that will stay up the whole time that says "Please wait, save in progress" while the rest of the code for the save runs. I just can't get the code straight to keep it up until the save is complete. Any Suggestions, Pre-Pre Thanks.

[HDR]

Try creating a tiny form with just a label on it that contains the text you want. Load it at the beginning of the save and unload it when the save is done.

[Juan Carlos Rey]

MsgBox are no-no for this purpose, as they require the user to take an action, such as clicking on a button for the program to continue. They are best suited for notification instead.

Use a small form as HDR suggested.

If you can split the saving action in parts or segments, then you can add a progress bar (3 or 4 segments are OK)
See http://www.vb-world.net/tips/tip40.html
HTH

Edited by Juan Carlos Rey on 02-27-2000 at 12:23 AM

[Chris]

if you create a tiny form like HDR suggested, then don't forgot to set the form to always on top, else it will hide behind the parent form upon the user click the parent form.