View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default 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