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 vote162 views1 answer
VBA is form loaded
VBA
8 votes200 views1 answer
Excel vba make word
VBA
1 vote153 views1 answer
Random number generator vb.net
VBA
0 vote147 views1 answer
Vba get relative cell address
VBA
0 vote157 views1 answer
Excel vba linter
VBA
0 vote145 views1 answer
Get current year vb
VBA
3 votes154 views1 answer
Vba request json
VBA
0 vote109 views10 answers
Vba excel create event log
VBA
0 vote155 views1 answer
Vba type
VBA
0 vote158 views1 answer
Vbnet round to nearnest thousand
VBA