Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Userform
Hi,
I have a macro that runs through 1000 scenarios. There is a userform that I update to display the progress. Basically it just shows the current scenario. So the macro runs through the 1000 scenarios and each time it goes to the next scenario it updates the Userform. So the code says UserForm1.Label1.Caption = CurrentScenario The problem is that when the macro is running the userform is white and you can't make out the Current Scenario. If I click ctrl-alt-delete and stop the macro the userform has the correct scenario displayed but then when I start it up again the number doesnt change. Is there some way to refresh the userform? Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh Userform
I have two suggestions: make sure you have a DoEvents command before starting
the next scenario; and add a Repaint command to the userform after updating the label caption (UserForm1.Repaint). Hope this helps, Hutch "Jeff" wrote: Hi, I have a macro that runs through 1000 scenarios. There is a userform that I update to display the progress. Basically it just shows the current scenario. So the macro runs through the 1000 scenarios and each time it goes to the next scenario it updates the Userform. So the code says UserForm1.Label1.Caption = CurrentScenario The problem is that when the macro is running the userform is white and you can't make out the Current Scenario. If I click ctrl-alt-delete and stop the macro the userform has the correct scenario displayed but then when I start it up again the number doesnt change. Is there some way to refresh the userform? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Userform with 5 textbox and 1 needs to refresh to have total | Excel Discussion (Misc queries) |