Keep Modal UserForm Alive after closing 2nd userform using 2007?

I've created a UserForm that I display as a Modal form. From that userform, I can launch a secondary userform by double clicking a field. The second form apears, displaying further information.

When I close the second form, the first Form(modal) also closes. I'm trying to get this first form to remain visible but have not been successful yet.

Any assistance would be most appreciated. I've attached a workbook with a simple example of the concept.

The objective I'm trying to achieve is to facilitate a "drill down" into a number displayed on a userform, to provide the detail that originally comprised that number. I thought a second UserFrom would be a good way to go as opposed to toggling on another box in the current form with it's visible property. In the real workbook I'm creating the first userform already contains a lot of data. I don't want to clutter it with more info. Any suggestions as to another way to achieve this objective would be most welcome.

Thanks,

Shred

I answered my own question. It seems that by default when I add a new userform to the project it's ShowModal property is set to True.

When I set this property to False for the secondary UserForm, I get the desired behavior.

I had read other threads about issues with using Modal UserForms, and understood there to be issues at times. Perhaps this is one of them.

I hope this can help anyone else encountering a similar issue.

Regards,

Shred