User Form Flickering

  • Thread starter Thread starter Saucer Man
  • Start date Start date
S

Saucer Man

I have a macro that creates many worksheets, emails them, and then deletes
them. I want to have a user form come up while the macro runs in the
background. With everything I tried, the user form flickers pretty badly
and the labels on it don't update while the macro is running. I have
several label.caption statements in the macro to show progress on the user
form. How do I make the form come up and remain in focus without flickering
as this macro does its thing?
 
Have you tried setting the ScreenUpdating property to True? For
example,

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Have you tried setting the ScreenUpdating property to True?
Click to expand...

ScreenUpdating should, of course, be False, not True.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
This works great. Thanks.


Chip Pearson said:
ScreenUpdating should, of course, be False, not True.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
Click to expand...
 
Back
Top