| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Shown while macro runs
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Shown while macro runs
So Tom, Put some ScreenUpdating commads around my hide
method for Userform1. It hid the form. However, when I call the second form, only the form is shown. It is shown white instead of its natural grey and its button is not shown. Do I have to put in a separate command for the button to show in modeless? 'Hide Main form Application.ScreenUpdating = False UserForm1.Hide Application.ScreenUpdating = True 'Load StatusBar Userform StatusBarUserform.Show vbModeless -----Original Message----- 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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Shown while macro runs
Application.ScreenUpdating = True
UserForm1.Hide 'Load StatusBar Userform StatusBarUserform.Show vbModeless doevents Application.ScreenUpdating = False Might work - hard to tell. -- Regards, Tom Ogilvy "ExcelMonkey" wrote in message ... So Tom, Put some ScreenUpdating commads around my hide method for Userform1. It hid the form. However, when I call the second form, only the form is shown. It is shown white instead of its natural grey and its button is not shown. Do I have to put in a separate command for the button to show in modeless? 'Hide Main form Application.ScreenUpdating = False UserForm1.Hide Application.ScreenUpdating = True 'Load StatusBar Userform StatusBarUserform.Show vbModeless -----Original Message----- 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
![ExcelMonkey[_190_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
