Application.Modules property (Access)

  • Article

Use the Modules property to access the Modules collection and its related properties. Read-only Modules object.

Syntax

expression.Modules

expression A variable that represents an Application object.

Remarks

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

Example

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.