Unloading a Userform unloads another as well??

[stirlingmw]

Help please

I have Userform1 that I use to add data to a workbook, within this Userform is a Cmdbutton that shows another Userform2 that is used to save worksheets as PDF. On completion Userform2 Unloads, however this action also closes Userform1. I am using

Please Login or Register  to view this content.

to unload the Userform. I have also tried using

Please Login or Register  to view this content.

but this opens an empty userform, and not the populated one.

Any Ideas??

Thanks

Steve

[Pepe Le Mokko]

Administrative note

Still using XL2003 as indicated in your profile?
If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
Thanks

[romperstomper]

I suggest you attach the workbook as it's a lot easier than trying to fathom all the possible causes of this behaviour. I assume that Userfrom1 was a typo.

[Richard Buttrey]

Hi,

Is there any code in the Userform2 Terminate event?

The easiest way to understand this is for you to upload the workbook so that we can see the problem in context.

Since Userform1 is closed then anything you captured in list/combo boxes will of course have disappeared and will not show the next time you open the form.

[stirlingmw]

All

Thanks for your replies, Richards got me thinking, I have code running when the terminate event is triggered. I have now moved this out of the main code and it seems to now work.

Thanks all