View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Gorham[_3_] Chris Gorham[_3_] is offline
external usenet poster
 
Posts: 31
Default Keping a UserForm open as VBA runs

Hi,

I'm designing a macro that takes a few seconds to run on
big sheets. I'd like to update the user on progress. I
could do this via the statusbar, but I'd prefer to have a
pop userform confirming the tasks as they complete.

the userform's I've developed before have to be hidden
before the code will run - how do I keep it open while the
code runs in the background..??

thks..Chris