Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Userform - unload (Excel 2000)

    Hi all again,
    This should be easy for thr pro's in here,

    I have several userforms that I have in a workbook, what I need to figure out is this.

    With my last Userform, I ask the User if they want to go back and make another input, it then loads the first form and starts all over, but it holds the values from the first time through, is there a way to make sure that all forms are set back to the original blank state?

    Have I done something wrong?

    Thank You in Advance for your help.


    Darryl.

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

    Re: Userform - unload (Excel 2000)

    You can use the form's initilize event to set the controls on the form to anything you want.
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Userform - unload (Excel 2000)

    When you use Userform1.Hide, the form stays in memory and so do all its values.

    Unload Userform1

    removes it from memory and thus resets all of its entries.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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