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.