Userform minimise or lose focus

[timbo44]

Hi,

I am putting together an application which is controlled via a userform. Part of the code has opened another workbook. There is a command button on the userform which needs to activate and show this workbook without closing the userform (this has values in list boxes and other controls).
Is there a way of showing the workbook by placing the userform in the background etc or will I have to write all the values on the userform to public variables, close the userform and when reopened, write these values back.

I hope I have explained fully

Thanks

 

[ck1999]

If you use userform.hide do they values get lost?

ck1999

 

[timbo44]

Your right, what a dummy I am!

Thanks, you've saved me a lot of time as I thought I would have to create another userform and write the spreadsheet values to that.

Sometimes you can't see the wood for the trees!

Regards