UserForm and user input
 

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

UserForm and user input
 

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

UserForm and user input
 

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