Results 1 to 2 of 2
  1. #1

    User Form Hide Problem

    In Excel 2000 when I call another sub from a button on a user Form, I can not seem to imediatly Hide the Form.
    Putting .Hide before or after the call in the button macro makes no difference.
    Putting the .Hide in the called routine also makes no difference.
    The Form stays visible until all code is run.
    How can I avoid this behaviour ????

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Re: User Form Hide Problem

    Two thoughts:

    1- Do you have ScreenUpdating set to false? If so, set it to True before hiding the form.

    2- Put a DoEvents statement after the .Hide to release the processor so that the screen can be updated.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts