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

1 vote256 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote231 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote274 views1 answer
Filesystemobject vba reference
VBA
0 vote224 views2 answers
Excel vba close without saving
VBA
0 vote255 views1 answer
Vba listbox remove all items
VBA
2 votes191 views1 answer
Excel vba pause
VBA
0 vote240 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote253 views1 answer
Vba random number
VBA
2 votes222 views1 answer
Excel vba extract file name
VBA
0 vote226 views1 answer
Vba file size
VBA