Msgbox from Userform - how to return to Userform and retain the inputs

Hello!

I have made a userform, and some of the fields are mandatory. I have created Msgboxs to appear if any of these are empty, prompting the user to go back and complete them. I have achieved this with:

Please Login or Register  to view this content.

where "sizingwizard" is the name of the Userform.

However, when I use this method, the Userform comes back empty. It's quite a large Userform, so if the user has spent 3 minutes filling it in and they miss a field, I don't want the Userform to get wiped of all their entries after the warning Msgbox goes away.

I also tried:

Please Login or Register  to view this content.

which omits the "Unload Me" part, but this gives me an error: "Form already displayed; can't show modally."

What can I do? Am I missing something obvious?? Thanks!

Set focus to the control...

Please Login or Register  to view this content.

Unloading the userform clears any input controls.

Thanks cytop, that's working better. The information in the userform is still there once the Msgbox has been dismissed. However, when I click "OK" on the Msgbox, the macro continues to run its course.

This particular macro runs when the user clicks a command button at the end of the form. Once the user clicks the command button, if one of the fields is empty, the warning pops up. When they click OK, the form reappears with the information still completed, but what's happening is that the command button macro still runs, ignoring the empty field. I want it to stop and wait for the user to click the command button again. Any thoughts?

Hi Norie, it's because I'm running into the same problem as I described in my reply to cytop above - once the user dismisses the Msgbox, the macro continues to run rather than stopping to let the user enter the correct information.

I have fixed it - a swift Exit Sub does the job! The Userform stays visible after the Msgbox is dismissed, complete with the info that was there before, and the user has to click the command button to run it again:

Please Login or Register  to view this content.

Thanks both for helping me think it through