Unloading Forms

**dfaunce83** · 02-27-2012, 10:36 AM

I have two forms in ActiveX:

(1) MainForm
(2) UserForm2

When the program initiates, MainForm is the first thing the user sees. If they click a particular button, then UserForm2 appears.
In UserForm2 I have a textbox and two buttons ("Cancel", "Add Vendor"). I want to make it such that if the user presses "Cancel", UserForm2 will disappear and guide them back to MainForm exactly how they left it.

My problem is that

Please Login or Register  to view this content.

will exit BOTH forms, I need it to only exit out of UserForm2. I've also tried Unload UserForm2 but received an error.

Any Suggestions?

**john55** · 02-27-2012, 10:41 AM

not sure but in cancel code button you can try this

Please Login or Register  to view this content.

**dfaunce83** · 02-27-2012, 10:54 AM

Hi John,
It was a good try but it still exits both.

**royUK** · 02-27-2012, 11:01 AM

UserForm1 needs to be Hidden not closed.

On UserForm1 add a button with this code

Please Login or Register  to view this content.

In UserForm2

Please Login or Register  to view this content.

**john55** · 02-27-2012, 11:04 AM

hi dfaunce83
it's hard to say what is happening there, could you make a test file with the issue and upload it here?
maybe someone gives you a solution

__sorry Roy!
did not see yr solution!

**dfaunce83** · 02-27-2012, 11:10 AM

royUK,

Thank you, this is perfect. My other option was to use an inputbox, but this works great.

**royUK** · 02-27-2012, 11:55 AM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save