VBA Userform Control of multiple userform controls

I have several forms that I am trying to manage a user thru to enter test data with test procedure prompts.I have a main intro form, several test prompt and input forms and a final close form to review, save and print the data report sheet in excel.

I want the user to be able to navigate between the forms. Using the "frmTest.Hide" command does not hide the form and "Unload frmTest" does not unload the form. The forms are staying persistant in the view space. They do decrease in view Z-Order, but they do not go away or become hidden with the form commands. The old forms persist in the background. So when I then try to go back to some of the forms to allow re-entry of data, for instance, I get an error that VBA does not allow modal forms to be displayed and the application errors and quits. These are typical form commands in VB6 and have worked successfully with VB6 without issues. So why does VBA have a problem managing forms and controlling what is visible or loaded, which form can be active and how would one then make forms hidden or unloaded in VBA. By the way, I had code command examples in my original post. Please advise if this makes my primary post more understandable.

SunshineDesign at 2007-8-31 >