Consulting

Results 1 to 3 of 3

Thread: How to avoid gosth userforms on screen

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Nov 2008
    Posts
    6
    Location

    How to avoid gosth userforms on screen

    I have two userforms on screen, one pops out when I click a button in the spreedshet; the second userform pops out when I click a button in the first form. The problem I have is, when the second userform shows up, if I move it I can see on the screen the same userform as many times as I move it. Is there any way to prevent this from happening? Originally I thohght I could eliminate this problem by using

    [vba]Application.ScreenUpdating = True[/vba]
    but the problem still persists. I have attached a jpg showing my problem.

  2. #2
    VBAX Master CreganTur's Avatar
    Joined
    Jan 2008
    Location
    Greensboro, NC
    Posts
    1,676
    Location
    Take a look at the Unload method. This unloads, or closes, a userform.
    -Randy Shea
    I'm a programmer, but I'm also pro-grammar!
    If your issue is resolved, please use Thread Tools to mark your thread as Solved!

    PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003


  3. #3
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    something else going on here I suspect......you shouldn't have that many showing unless they are opened repeatedly....

    post the workbook that is doing this.......
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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