Consulting

Results 1 to 8 of 8

Thread: Form tracing around screen

  1. #1

    Form tracing around screen

    Hi

    I have a userform that allows users to enter Project information which is fine. However, when I delete a Project the information clears the screen but does not update the underlying spreadsheet until I close the form. When I tmove the actual form around the screen it seems to copy itself almost like a tracer. The tracer will disappear when I close the form.

    Does anyone have any ideas what I am doing wrong and how to make the form more responsive.

    Thanks

    Ian

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    I occasionally get that glitch, but never discovered a reason. Can you post a sanitised example to see if the problem manifests here?
    Regards
    MD
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  3. #3
    Unfortunately the file is too large to be posted. It does do it on other computers though.

    Thanks

    Ian

  4. #4
    Hi MD,

    I see you are from Scotland. So am I. Just moved to the US. I think I also need to change the flag from Albanian to USA.

    Cheers

    Ian

  5. #5
    Ok MD,
    I've just e-mailed it to you,

    Thanks

    Ian

  6. #6
    Administrator
    VP-Knowledge Base VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    I've had a look, and while I get some flicker I don't get the trace.
    I'm guessing that there are just too many cotrols on your form for the graphics to handle.
    Try deleting half of them and see if there is any change.
    Regards
    MD
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  7. #7
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Could it be a graphics card/memory problem on Ian's computer?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  8. #8
    VBAX Master XLGibbs's Avatar
    Joined
    Jan 2006
    Location
    state of confusion, but vacation in denial
    Posts
    1,315
    Location
    This almost surely sounds like there may be too much for the graphics card to handle. I have seen that while on my POS work computer when I might have 4 applications running, and there is a lot going on with fast changes to the screen. Sometimes it seems like the graphics card is not updating as fast as it should....
    If you have posted the same question at multiple forums, please read this IMPORTANT INFO.

    Please use the thread tools to mark your thread Solved


    Please review the Knowledge Base
    for samples and solutions , or to submit your own!




Posting Permissions

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