![]() |
#4
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Annby | Project | 3 | 11-06-2014 03:38 PM |
VBA Code in a UserForm module to delete a Command Button which opens the userform | Simoninparis | Word VBA | 2 | 09-21-2014 03:50 AM |
![]() |
BoringDavid | Word VBA | 5 | 05-09-2014 09:08 AM |
![]() |
ravl13 | Word | 3 | 11-21-2013 12:31 PM |
Need Help Getting Started, Please. Thanks | ChunkyZergling | Outlook | 1 | 04-24-2009 07:38 AM |