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 vote114 views10 answers
Vba excel create event log
VBA
0 vote136 views1 answer
Vbide vbproject reference
VBA
1 vote167 views1 answer
Close form vba
VBA
0 vote125 views1 answer
How to make a if statement with vbs
VBA
5 votes180 views1 answer
Excel vba left word from Long Integer
VBA
1 vote198 views1 answer
Vba format string as cash
VBA
0 vote131 views1 answer
How to sort datagridview in vb.net
VBA
0 vote170 views1 answer
Vba text to general
VBA
-1 vote181 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote165 views1 answer
Visual basic msdos
VBA