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
    Next  
End SUb

Similar codes

0 vote317 views1 answer
Style percent not found vba
VBA
0 vote280 views1 answer
Excel vba current folder
VBA
0 vote289 views1 answer
Vba find sub dictionary
VBA
0 vote316 views1 answer
Method showalldata of object _worksheet failed vba
VBA
0 vote310 views4 answers
Jwt token vb.net validation
VBA
0 vote294 views1 answer
Xlbycolumns is not declared
VBA
0 vote283 views1 answer
Reset border color textbox vba
VBA
12 votes380 views1 answer
Excel vba write string to text file
VBA
0 vote307 views1 answer
Excel vba prevent saving workbook
VBA
3 votes293 views1 answer
Excel vba change format of cell
VBA