View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Saucer Man Saucer Man is offline
external usenet poster
 
Posts: 54
Default User Form Flickering

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!