Skip to content

Passing Arrays to Compiled VBA Code

You can pass different variable types to the compiled VBA code, including static arrays.

Suppose you have the following function in the VBA compiler:

Function TestMultipleParams(Param1, Param2, Param3)
  MsgBox(Param2(1))
  TestMultipleParams = Param3 ^ 2
End Function

In your normal Excel VBA module, you can call this function and pass an array.

Sub MySubSample4()
    Dim XLSPadlock As Object
    Set XLSPadlock = Application.COMAddIns("GXLSForm.GXLSFormula").Object


    Dim NomTableau(2) As Variant
    NomTableau(0) = "a"
    NomTableau(1) = "b"
    NomTableau(2) = "c"


    MsgBox XLSPadlock.PLEvalVBA3("TestMultipleParams", "Param1", NomTableau, 3)


    Set XLSPadlock = Nothing
End Sub