Hide userform in VBA in order to work with data

Question

I have a following problem. I would like to hide a userform in order to work with data in worksheet.

I would like to enable user to get back to application. So I thought if there is a possibility to move userform down on the screen and activate workbook. Afterwards the user could drag userform back in the middle of the screen and work with it again.

Does anyone have an experience with something like that?

Answer 1

You can use me.hide to hide userform, retaining all values entered into the form. Use me.show to bring back the userform to the screen.

This is different from unload me, which unload the userform from memory, destroying all values entered. Calling the form again will start the form a new.

If you want the form to be still visible and allow user to interact with worksheet behind, then set the ShowModal property to False.. The default is True.