User Form Flickering

[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?

 

[ward376]

Try displaying the form modeless -

YourForm.Show vbModeless

Cliff Edwards

 

[Chip Pearson]

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)

 

[Chip Pearson]

Have you tried setting the ScreenUpdating property to True?

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)

 

[Saucer Man]

This works great. Thanks.

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)