USERFORM DISAPPEARS ON EXCEL MINIMIZE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian Digby - 09 Jan 2006 13:08 GMT

When I minimize Excel, my VBA Userforms disappear. I thought the Userform
ThunderdFrame class window was not a child of Excel, so why does it
disappear?

Any help would be much appreciated.

Signature

Work performed in the spirit of service is worship...Baha'i Writings

Reply to this Message

Tom Ogilvy - 09 Jan 2006 15:02 GMT

I haven't observed this behavior.

as an example, putting this in the userform module:

Private Sub UserForm_Initialize()
Application.Visible = False
End Sub

Private Sub UserForm_Terminate()
Application.Visible = True
End Sub

worked fine, showing the useform as modal or modeless

Signature

Regards,
Tom Ogilvy

> When I minimize Excel, my VBA Userforms disappear. I thought the Userform
> ThunderdFrame class window was not a child of Excel, so why does it
> disappear?
>
> Any help would be much appreciated.

Reply to this Message

Ian Digby - 25 Jan 2006 08:50 GMT

Tom,
Thanks for this observation. I discovered that the cause of this problem was
the existence in memory of a "garbage" form object. Earlier in the code I had
instantiated a different form class but had not set it to "Nothing".

When Excel was minimized, this caused it to destroy the later form object.

I do not understand the mechanics of why Excel did this but anyone
experiencing similar problems should check whether they have un-terminated
form classes which have been finished with, and set them to Nothing before
displaying their latest form.

Any further discussion/observations would be most welcome.

Ian

Signature

Work performed in the spirit of service is worship...Baha''''i Writings

> I haven't observed this behavior.
>
[quoted text clipped - 15 lines]
> >
> > Any help would be much appreciated.

Reply to this Message