Modeless userform OLEObject Add problem
Hi Bob,
I mailed the test workbook i am using to your email address.
Is the form you are bringing up modal or modeless?
My issue is that the code works fine if the form is modal.
But the form disappears on addition of any controls to the active sheet
when it is modeless.
You can try adding multiple objects in one iteration.
The effect is that it adds all the controls of the iteration, runs fine
to completion and then disappears.
It does not fire any exiting event.
I dont know if it is a version specific problem.
Mine is excel 2002 version 10.2614.2625
Thanks for your help.
Regards,
Jayant
|