+ Reply to Thread
Results 1 to 4 of 4

UserForm(s) overlapped if it's moved...

  1. #1
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    UserForm(s) overlapped if it's moved...

    hi guys,

    I have a file with some userforms (I use it at office), if I want to move the userform up or down, to the left or right ...the images are overlapped.I attached a test file with some screen shoots to show you how the userform looks like if I move it.
    The same file does not have this "issue" on my laptop/desktop home.
    At office I use another file (which is bigger than the first one!) with some userforms and it works fine, I move the userform without any problem!
    Have you seen before someting like this?

    I appreciate your help!
    Attached Files Attached Files
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,429

    Re: UserForm(s) overlapped if it's moved...

    Userform ghosting is normally caused by Application.Screenupdating being switched off, although your code example does not contain such code.
    I have also seen it when a hidden worksheet is activated, not selected, via code.

    BTW, Your example works fine for me.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: UserForm(s) overlapped if it's moved...

    hi Andy,
    this is a test file just to show you how the file from my office looks like if I try to move the userform. yes, you are right, this one it works fine, it's just a test!
    when i go to my office I'll try to play with Application.Screenupdating on/off for the entire file.
    I'll check the hidden sheets also to be hidden by code...!
    If you would not mind I'll call you to tell what I find/solve or!!
    thank you very much for your response.

  4. #4
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: UserForm(s) overlapped if it's moved...

    hi Andy,
    I checked the code for every userform, all of them have Application.Screenupdating on/off! I do not know why the userforms look as the screen pictures attached when are moved here on this machine and on my laptop are ok!
    I have no any problems with other files!

    thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1