You can open another form that is postioned over an existing form, in the
initialize event of the first form use

Load Userform2

this makes the controls on userform2 available to your program, but not
visible or accessile to the user. So you can set values, fill lists etc.,
and the form sits in memory ready for use. Then when you want the second
form to be activated use

Userform2.Show False (False sets the form modeless, in xl97 use -
Userform2.Show - as all forms are modeless)

The second form takes focus, the first form controls are no longer active
yet visible. You should remove the title bar of the second form to prevent
it being moved relative to the first form (and for aesthetic reasons?).
When Userform2 is no longer required (to be user accessible) use

Userform2.Hide

Controls on both forms can still be accessed programmatically until you
finally to get rid of them using

Unload Userform2
Unload Userform1


--
Cheers
Nigel



"pjw" wrote in message
...

Does anybody know how to place a form inside of a form in Excel?

I have one form with buttons that perform "click events". I would like
to place another form on (in) this form. Can it be done?

Thanks


--
pjw
------------------------------------------------------------------------
pjw's Profile:
http://www.excelforum.com/member.php...o&userid=24394
View this thread: http://www.excelforum.com/showthread...hreadid=379972