Answers for "vba multiple optional arguments"


vba multiple optional arguments

' Use a ParamArray
Sub Test(ByVal pArg As String, ParamArray pParameters() As Variant)
	' Can't be combined with 'Optional' arguments
    Dim sValues
    For Each sValues In pParameters
  Debug.print sValues
End SUb
Posted by: Guest on January-30-2021

Code answers related to "vba multiple optional arguments"

Code answers related to "VBA"

Browse Popular Code Answers by Language