Userforms & Excel 2002 Crashes

S

Steve

Hello

I'm hitting an issue with Excel 2002 which I believe may be due to the
way that I'm defining & using UserForm objects.

Lets say I define a new form & call it frmMyForm

then within a button macro, if I use:

Dim myFrm as frmMyForm
set myFrm=new frmMyForm


I'm finding that Excel will periodically crash, or that you can't
simply right click other buttons to access their macros.

I believe that I'm disposing the form objects correctly as I can see
the Terminate macro being called when the form is closed, the purpose
of which I use to set any persisted object reference to nothing.

The reason why, I'm using the Form definition as a type rather than a
predefined object, is that I can simply create several instances of
the same form which can be open at the same time each persisting
different data sets.so the user perssing the button macro several
times can have the same form window opened several times and use each
window to display different data sets.

Are there any known issues with using this form (excuse the punn) of
invokation ? Or even with embedding Scripting.Dictionary, and 2d/3d
variant arrays within a Form Class code ?


Thanks in advance,


Steve.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top