Unload Userform

[saltkev]

Hi

Is it possibleto unload a userform, rather than just hiding it's visible property with "MyUserform.hide". I have a problem when calling the form at a later stage with "MyUserform.show. The form seems to be still resident, but not visible.

Any ideas

regards

Kev

 

[VoG]

Try like this

Private Sub CommandButton1_Click()
Unload UserForm1
End Sub

 

[saltkev]

Top Job

Thanks