Vba variable number of arguments

Sub Test(ByVal pArg As String, ParamArray pParameters())
	' Can't be combined with 'Optional' arguments
    Dim sValues
    For Each sValues In pParameters
  Debug.print sValues
    Next  
End SUb

Similar codes

3 votes130 views1 answer
Vba make long from two shorts
VBA
1 vote146 views1 answer
Vba optional
VBA
0 vote140 views1 answer
Find database connection string vb
VBA
1 vote142 views1 answer
Sort using vba
VBA
0 vote126 views1 answer
Excel vba address not absolute
VBA
1 vote77 views1 answer
Ms access open form to new record
VBA
0 vote134 views1 answer
Excel vba convert cells address
VBA
8 votes210 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote156 views1 answer
Excel vba protect shapes
VBA
0 vote141 views1 answer
Default host vbox address
VBA