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?

--
Thanks!

Try displaying the form modeless -

YourForm.Show vbModeless

Cliff Edwards

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)

On Fri, 27 Feb 2009 11:47:37 -0500, "Saucer Man"
wrote:

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?

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)

On Fri, 27 Feb 2009 11:14:49 -0600, Chip Pearson
wrote:


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)

On Fri, 27 Feb 2009 11:47:37 -0500, "Saucer Man"
wrote:

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?

This works great. Thanks.


"Chip Pearson" wrote in message
...

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)

On Fri, 27 Feb 2009 11:14:49 -0600, Chip Pearson
wrote:


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)

On Fri, 27 Feb 2009 11:47:37 -0500, "Saucer Man"
wrote:

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?