Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,119
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
differentiate between a visible and a hidden userform RB Smissaert Excel Programming 2 June 30th 05 10:11 PM
Userform always visible StephanieH Excel Programming 3 June 23rd 05 09:20 PM
Shapes, Userform and Visible Joel Mills Excel Programming 4 May 31st 05 02:40 AM
UserForm: Jump to the next visible cell Gabor G Excel Programming 2 April 6th 04 02:00 PM
Excel: VBA userform is shown but not loaded/initialized even though it was first unloaded? Luisa[_2_] Excel Programming 2 December 5th 03 08:15 AM


All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"