Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Non -Modal form disappears

I created a Non-modal form but when i run code in its
initialize event it disappears. dose anyone know why im
getting this behavior or how to prevent it. Im using
MSoffice 2000 on win98
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default Non -Modal form disappears

Have you fully tested the code you are using in the event procedure? Does
the code set any of the form's properties? Most likely cause is something in
that procedure...

"Chris W" wrote:

I created a Non-modal form but when i run code in its
initialize event it disappears. dose anyone know why im
getting this behavior or how to prevent it. Im using
MSoffice 2000 on win98

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 42
Default Non -Modal form disappears

"Chris W" wrote:
I created a Non-modal form but when i run code in its
initialize event it disappears.


How do you mean the form disappears? The Initialize event runs before the
form is displayed. Tell us how you're invoking the Initiailize event. Note
that you can cause the Initialize event to execute without the form ever
becoming visible. That will happen if you call Load on the form but never
call Show.

Do you have code in the Activate event? That fires after the form is
visible. Do you ever call Hide on the form?

One possibility is that the form is there, but it's where it can't be seen.
After you do whatever is supposed to show the form, go to the VBE Immediate
window. Put the following on a blank line and hit return.

?UserFormName.Visible

If you get true, then check the form's .Left and .Top properties. If you
get false, you're probably not making it through the Load/Initialize/Activate
process.

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
Forms that are modal in 97 are not modal in 2003 Old Car Excel Discussion (Misc queries) 1 April 27th 05 08:25 AM
MODAL vs. NonMODAL JimP Excel Programming 5 November 18th 04 01:21 PM
Modal oddity Ken McLennan[_3_] Excel Programming 2 May 27th 04 06:49 AM
Modal User Form Jim M[_3_] Excel Programming 1 November 4th 03 10:38 PM
Modeless form disappears on deleting sheet Walter Martin Excel Programming 1 August 3rd 03 11:07 AM


All times are GMT +1. The time now is 04:16 AM.

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

About Us

"It's about Microsoft Excel"