Access VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Access
  4. The AllMacros collection allows you to iterate through all macros stored in the current project
Sub IterateAllMacros()
    Dim vnt As Variant
    With CurrentProject
        For Each vnt In .AllMacros
            Debug.Print vnt.Name
        Next vnt
    End With
End Sub