Doevents Application

  • Thread starter Thread starter Alex J
  • Start date Start date
A

Alex J

All,

I have seen (and used experimentally) the DOEVENTScommand to speed up
Userform performance, but after looking at MS KnowledgeBase and a
GoogleSearch of this NG, I am not clear on the best strategies to use
DOEVENTS.

Why does it speed up Userform execution if what it does is let other
processes run?
When is the best time to use and not use DOEVENTS?

Can it be used at other junctures in the code to provide for 'snappier' UI
performace?

Expertise and experience on the topic would be greatly appreciated.

Best Regards,

Alex J
 
Alex said:
Why does it speed up Userform execution if what it does is let other
processes run?
Click to expand...

I doubt it actually speeds up Userform execution - but it might allow a
screen updating task to run that would make it appear to have speeded
up the execution?...

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top