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
Printable View
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
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