Open and closing a form

[daved2424]

How do I close one form and open another in Excel when clicking on a command button? Simple problem I know, just something I havn't needed to do before.

Many Thanks

[TheFIDDLER]

Code for your button click event with the following:

Unload Me
frmNew.show

However, if you plan to return to the first form, rather than unloading it from memory, you can just hide it.

Me.hide
frmNew.show