Close just one userform

[thedogg]

Is it somehow possible to close just one userform if I have had two opened? I have a button in userform1 which is calling userform2 but if I close userform 2 both are gone. I know that I can call/show again userform1 but I want to avoid doing it. If I did so I wouldn't keep the chnges I had made.

 

[Yongle]

This is not default behaviour. I created your scenario and the first userform does not close.
- so there must be something in your code or settings that makes this happen

Please post
... the procedure that calls userform2 (the complete procedure)
... the procedure that closes UserForm1
... UserForm_Deactivate if either userform use this procedure
... is there anything pertaining to UserForm1 status in UserForm2's UserForm_Initialize or UserForm_Activate

Please use code tags around your code by clicking on # icon above post window first and pasting your code between the tags
thanks

 

[My Aswer Is This]

If you close a Userform like this you loose all the data in the Userform

Unload UserForm1

If you close a Userform like this you do not loose the data in the Userform as long as the Workbook stays open
UserForm1.Hide