Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Application.Modules Property (Access)

You can use the Modules property to access the Modules collection and its related properties. Read-only Modules object.

expression .Modules

expression A variable that represents an Application object.

Use the properties of the Modules collection in Visual Basic to refer to all open standard modules and class modules.

The following example uses the Module property to insert the Beep method in a form's Open event.

Dim strFormOpenCode As String 
Dim mdl As Module 
Set mdl = Forms!MyForm.Module 
strFormOpenCode = "Sub Form_Open(Cancel As Integer)" _ 
 & vbCrLf & "Beep" & vbCrLf & "End Sub" 
 With mdl 
 .InsertText strFormOpenCode 
 End With
© 2015 Microsoft