Accessing Macro Functions from VBA Modules

To access macro functions from VBA modules, use the Run method.

Run ("macro_function", arg1, ...)

Example

Sub Elemlist( )
    Worksheets("Sheet1").Select
    Cells(3,5).Select
    ActiveCell.Value = Run ("E_PICK", "local:Region")
End Sub

This procedure calls the E_PICK macro function, which accesses a list of elements in the Region dimension. The selected element populates a cell in the Sheet1 worksheet.