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.
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.