Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
Userform runs other subs when initialized | Excel Programming | |||
Keping a UserForm open as VBA runs | Excel Programming | |||
Excel: VBA userform is shown but not loaded/initialized even though it was first unloaded? | Excel Programming |