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?:confused:
Printable View
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?:confused:
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.
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.Quote:
Originally Posted by dinosaur_uk
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.
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?
resolved
Code:Application.ScreenUpdating = True