UserForm and user input

  • Thread starter Thread starter RHall
  • Start date Start date
R

RHall

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?
 
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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform Textbox to Worksheet Textbox 1
Userform textbox string to header causes unwanted double spacing 4
save user inputs from userform in a seperate workbook 6
Allow text in locked cells on a worksheet from a userform 16
userform textbox returns changeable date 4
Load Userform on Workbook_Open()?? 1
Checking to see if a user form is hidden 5
Worksheet appears briefly before UserForm opens 4

Back
Top