View Single Post
 
Old 12-14-2014, 04:30 PM
Charles Kenyon Charles Kenyon is offline Windows 7 64bit Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,453
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

My understanding is that it is best to create a new form rather than show the basic one. I believe this is a method of saving memory.

Code:
Sub StartUserForm()
    Dim myNewForm As myForm
    Set myNewForm = New myForm
    myNewForm.Show
    Unload myNewForm
    Set myNewForm = Nothing
End Sub
Reply With Quote