Loading a Form into Memory Prior to Displaying It : Form « Forms « VBA / Excel / Access / Word

Loading a Form into Memory Prior to Displaying It


Sub ModifySimpleForm() 
    Dim sNewCaption As String 

    Load frmSimpleForm 

    sNewCaption = InputBox("Enter a caption for the form.") 

    frmSimpleForm.Caption = sNewCaption 


    MsgBox "OK - same form again except with default caption", vbOKOnly 
End Sub 


Related examples in the same category

1.Change caption
2.Display form in Modal mode
3.Close a form
4.To remove the Userform from the computer's memory, you must use the Unload statement; otherwise, the Userform is only hidden.
5.Creating UserForms Programmatically
6.Adding Controls to a UserForm at Design Time
7.Output form to html file
8.Using the Show Method to Display a Form
9.Cancels a cancelable event (an event that has a Cancel parameter).
10.Open a form, format the fonts and close it
11.Format fonts
12.Form count