All, I have developed several tools for members of my team. Each of these is driven by an icon on the outlook ribbon that simply calls a routine in a standard module. All this does is show the userform. From there on, all the code (lots) is in each of the various userforms.
Now that all that is built and working just fine, we decided to consolidate all the tools into a master menu userform that has a sidebar menu to determine which tool to run. That part of this is no big deal. This eliminates all the various icons on the outlook ribbon except for 1 that runs this master menu page.
The issue I have is I would like to run all the existing userforms as child control of either a frame or multipage control on the master menu form. I know I have the option of creating a multipage control on the master and just hiding/showing the pages based on the user selection, but that means I would have to copy all the controls/code to the master menu userform. I really don’t want to do that as that is a lot of controls and code to copy and be all inside 1 userform making a mess for maintaining when it would be best to keep them all separated as they are now.
Since all the userforms are all coded and working fine, I would like to use them as is, but from the confines of a container on another userform. I have not been able to find a way to change the parent of a userform to be a frame or multipage control on another userform or to be able to add a userform to a multipage control.
Is this even possible or am I stuck having to copy all the controls and code to the new form?
Hope this made sense.
Many TIA.