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 vote375 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote337 views1 answer
Excel vba calculate
VBA
0 vote367 views1 answer
Move bindingnavigator vb
VBA
0 vote315 views1 answer
Check range is in another range vba
VBA
8 votes423 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote329 views1 answer
Vba type
VBA
0 vote293 views1 answer
Excel vba arrondir
VBA
0 vote329 views1 answer
Vba simple quote
VBA
5 votes317 views1 answer
Vba array worksheet.index
VBA
0 vote324 views1 answer
Excel vba automatic calculation
VBA