Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm unloaded still visible
Is your screen updating off. This can cause difficulties. Try toggling the
screen updating to refresh. You may get a background flash if you have been moving the active sheet/cell around... -- HTH... Jim Thomlinson "allenj3" wrote: I unload a userform which is shortly followed by another form, which is "modeless" containing a progress bar. Even though the first form is unloaded, when the second form pops up, the first form is still visible behind the second. I even tried hiding the first form prior to unloading it but that didn't work either. Any ideas would be greatly appreciated. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UserForm unloaded still visible
Jim,
The screen updating was on, I believe (the Application.ScreenUpdating property already had a value of "TRUE"); however, when I put the command Application.ScreenUpdating = True right before I load the second userform it successfully makes the first form disappear! Thanks for your help! "Jim Thomlinson" wrote: Is your screen updating off. This can cause difficulties. Try toggling the screen updating to refresh. You may get a background flash if you have been moving the active sheet/cell around... -- HTH... Jim Thomlinson "allenj3" wrote: I unload a userform which is shortly followed by another form, which is "modeless" containing a progress bar. Even though the first form is unloaded, when the second form pops up, the first form is still visible behind the second. I even tried hiding the first form prior to unloading it but that didn't work either. Any ideas would be greatly appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
differentiate between a visible and a hidden userform | Excel Programming | |||
Userform always visible | Excel Programming | |||
Shapes, Userform and Visible | Excel Programming | |||
UserForm: Jump to the next visible cell | Excel Programming | |||
Excel: VBA userform is shown but not loaded/initialized even though it was first unloaded? | Excel Programming |