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 vote353 views1 answer
Sendkeys vba selenium
VBA
0 vote354 views1 answer
Vba simple quote
VBA
0 vote400 views1 answer
Excel vba Column Name from Column Number
VBA
0 vote360 views1 answer
Excel vba delete folder
VBA
20 votes509 views1 answer
Excel vba factorial
VBA
2 votes345 views1 answer
Date format for ms chart vb.net
VBA
0 vote374 views1 answer
Return na vba
VBA
4 votes358 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote337 views1 answer
Excel vba existence of a file
VBA
5 votes344 views1 answer
Vba array worksheet.index
VBA