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 vote189 views1 answer
Pivot data source not accepting table named range vba
VBA
1 vote180 views1 answer
Export datagridview to excel vb.net
VBA
0 vote183 views1 answer
Sendkeys vba selenium
VBA
0 vote173 views1 answer
How to extract a file from an ISO:
VBA
0 vote150 views1 answer
Vba select file in folder
VBA
0 vote193 views1 answer
Delete all controls in an area vb
VBA
1 vote181 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote188 views1 answer
Excel vba unlock sheet without password
VBA
0 vote174 views1 answer
Add items to combobox vb.net
VBA
0 vote189 views1 answer
Excel vba cell on change
VBA