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 vote351 views1 answer
VBA is form loaded
VBA
0 vote258 views10 answers
Vba excel create event log
VBA
3 votes361 views1 answer
Vba make long from two words
VBA
2 votes326 views1 answer
Excel vba check if key is in collection
VBA
0 vote346 views1 answer
Vba sheet hide unhide
VBA
8 votes393 views1 answer
Vba make integer
VBA
1 vote364 views1 answer
Vb.net get name by Cell Click
VBA
0 vote352 views1 answer
Vba array dimensions
VBA
0 vote358 views1 answer
Vba parameter adodb null value
VBA
31 votes481 views1 answer
Excel vba function to convert column number to letter
VBA