-
Jun 6th, 2007, 04:46 AM
#1
Thread Starter
Frenzied Member
-
Jun 6th, 2007, 04:57 AM
#2
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
-
Jun 6th, 2007, 05:00 AM
#3
Thread Starter
Frenzied Member
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
-
Jun 6th, 2007, 05:11 AM
#4
Re: Strange form? Excel screwing up?
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
-
Jun 6th, 2007, 05:15 AM
#5
Thread Starter
Frenzied Member
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
-
Jun 6th, 2007, 05:19 AM
#6
Thread Starter
Frenzied Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|