Results 1 to 6 of 6

Thread: [RESOLVED] Strange form? Excel screwing up?

  1. #1

    Thread Starter
    Frenzied Member dinosaur_uk's Avatar
    Join Date
    Sep 2004
    Location
    Jurassic Park
    Posts
    1,098

    Resolved [RESOLVED] Strange form? Excel screwing up?

    Hi there,

    I have written a VBA form and when i run it, (it does some iteration) and it works fine, but when i move the form around, it leaves a trail behind!

    Any ideas?
    Attached Images Attached Images  
    If you find my thread helpful, please remember to rate me

  2. #2
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: Strange form? Excel screwing up?

    Most probably the Iteration that it is doing is causing it to leave trails. Which means the Form is not getting painted again and the system is busy with doing something else.
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  3. #3

    Thread Starter
    Frenzied Member dinosaur_uk's Avatar
    Join Date
    Sep 2004
    Location
    Jurassic Park
    Posts
    1,098

    Re: Strange form? Excel screwing up?

    argh....i need to clean up the iteration....how can i tell it to stop all subs?
    If you find my thread helpful, please remember to rate me

  4. #4
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: Strange form? Excel screwing up?

    Quote Originally Posted by dinosaur_uk
    argh....i need to clean up the iteration....how can i tell it to stop all subs?
    Stop All Subs? Well that depends on how your procedures are working.

    You can either use DoEvents in your loops to make the Form Responsive to other events. But keep in mind that is going to slow down your loops.
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  5. #5

    Thread Starter
    Frenzied Member dinosaur_uk's Avatar
    Join Date
    Sep 2004
    Location
    Jurassic Park
    Posts
    1,098

    Re: Strange form? Excel screwing up?

    Yeah, but i have exited the Do loop already ...i have stepped though it and it doesn't iterate once i have exited the sub...

    what is the best way to break out of a loop?
    If you find my thread helpful, please remember to rate me

  6. #6

    Thread Starter
    Frenzied Member dinosaur_uk's Avatar
    Join Date
    Sep 2004
    Location
    Jurassic Park
    Posts
    1,098

    Re: Strange form? Excel screwing up?

    resolved

    Code:
    Application.ScreenUpdating = True
    If you find my thread helpful, please remember to rate me

Posting Permissions

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



Click Here to Expand Forum to Full Width