I have a "template" userform, let's call is formTemplate. Programatically I wish to create several instances of it, say, formA, formB and formC. Each instance will be retained and visible while the application is running and then (probably) deleted when the application exits. Questions:

1. how do I create (programatically with VBA) a new instance (or copy) of the original userform

2. how do I keep the instance visible (and alive) while allowing the user/application to do other things (unless the user clicks the X to remove the instance).

I plan to keep the instance names in a text array somewhere and delete all instances when the appl exits.

Any help would be appreciated.

Thanks