StatusBarUserform.Show vbModeless

the default is to show in a modal mode - meaning it behaves as you describe.
Note that xl97 does not support the vbModeless argument. Its userforms are
modal. (using built in functionality).

--
Regards,
Tom Ogilvy

"ExcelMonkey" wrote in message
...
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