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

4 votes149 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
1 vote131 views1 answer
What does vbs stand for
VBA
0 vote135 views1 answer
Vbnet line graph smooth lines
VBA
22 votes261 views1 answer
Excel vba check if directory exists
VBA
0 vote130 views2 answers
Excel vba prevent save
VBA
1 vote162 views1 answer
Perform http request in vb.net
VBA
0 vote127 views1 answer
Vba word pdf table to excel
VBA
5 votes86 views1 answer
Vlookup vba
VBA
0 vote137 views1 answer
Vba apostrophe chr
VBA
1 vote137 views1 answer
Excel vba last column in range
VBA