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 vote212 views1 answer
Vbnet check if string is only symbols
VBA
0 vote267 views1 answer
Vba excel parser xml
VBA
0 vote226 views1 answer
Supprimer la valeur de celule vba
VBA
1 vote211 views2 answers
Vba function return array
VBA
0 vote231 views1 answer
Vba exit while
VBA
2 votes233 views1 answer
Excel vba extract file name
VBA
0 vote210 views1 answer
Vba add shape oval
VBA
0 vote230 views1 answer
Vb.net change cursor to wait
VBA
1 vote216 views1 answer
Excel vba make cell visible
VBA
1 vote235 views1 answer
Set font for ms chart vb.net
VBA