Using the Show Method to Display a Form : Form « Forms « VBA / Excel / Access / Word

Using the Show Method to Display a Form

Sub SimpleFormExample() 
    ShowSimpleForm True 
    MsgBox "OK - Same form now, but modeless.", vbOKOnly 

    ShowSimpleForm False 
    MsgBox "Exiting the SimpleFormExample procedure.", vbOKOnly 
End Sub 
Private Sub ShowSimpleForm(bModal As Boolean) 
    If bModal Then 
        frmSimpleForm.Show vbModal 
        frmSimpleForm.Show vbModeless 
    End If 
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.Loading a Form into Memory Prior to Displaying It
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