ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   DoEvents(?) issue (https://www.excelbanter.com/excel-programming/420678-doevents-issue.html)

avi

DoEvents(?) issue
 
Hello,

I have a code that should load EzPaste form as a kind of splashscreen
and unload it when the main form (BinsUserForm) finishes to load and
show

EzPaste.Show
DoEvents
BinsUserForm.Show
Unload EzPaste

The problem is that after the main form (BinsUserForm) is loaded and
displayed, the first one (EzPaste) shows itself again for a few
milliseconds and disappears after that

Is there a way to cancel the display of EzPaste the second time after
BinsUserForm is displayed?

The main form is a quite heavy one with a lot of boxes and commands
buttons, making it slow to load

Thanks a lot
Avi



[email protected]

DoEvents(?) issue
 
Hi
Why not unload EzPaste before you show BinsUserform? If you need
values from EzPaste simply capture them as variables before unloading
the form.
regards
Paul

On Nov 30, 4:50*pm, avi wrote:
Hello,

I have a code that should load EzPaste form as a kind of splashscreen
and unload it when the main form (BinsUserForm) finishes to load and
show

* * EzPaste.Show
* * DoEvents
* * BinsUserForm.Show
* * Unload EzPaste

The problem is that after the main form (BinsUserForm) is loaded and
displayed, the first one (EzPaste) shows itself again for a few
milliseconds and disappears after that

Is there a way to cancel the display of EzPaste the second time after
BinsUserForm is displayed?

The main form is a quite heavy one with a lot of boxes and commands
buttons, making it slow to load

Thanks a lot
Avi




All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com