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 J wrote:
Why does it speed up Userform execution if what it does is let other
processes run?


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