View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
jjk jjk is offline
external usenet poster
 
Posts: 42
Default 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