Thanks for your time, I need more. The vbmodeless did not seem to do
anything. I could hide the form so the user can work on the sheet. How do I
get back to the userform. Do I need an OnEvent type of command and if so
where do I put it?
--
none


"JP" wrote:

You can make the form modeless when displaying the form

FormName.Show vbModeless

or use FormName.Hide to temporarily hide the form (without unloading
it from memory) and then FormName.Show to re-display it.


HTH,
JP

On Feb 11, 8:12 pm, RHall .(donotspam) wrote:
I have a user form to let the user select what they want. I load the
appropriate workbook and want to allow them to work on it. How do I get the
userform out of the way and get back to it when the user is finished making
changes to the worksheet?
--
none