View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default Userform Shown while macro runs

I have a macro that runs over a few minutes. While its
running, I want to able to display a userform. I want the
form to have a cancel button which will stop the entire
routine.

When I initiate the macro its off the OKButton_Click
event. I call the form I want to see.

'Load StatusBar Userform
StatusBarUserform.Show

When I do this, the macro doesn't continue running. That
is, without this call stmt, the macro does its thing.
Here is just sits idle. Why does the act of showing this
form stop the macro from progressing? I want to see this
form and also have the code advance.

Then I want to be able to hit cancel and have all the
forms unload and hide

Thanks