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 vote214 views1 answer
Vba find last column in a row with data
VBA
0 vote222 views1 answer
Vba get application version
VBA
0 vote241 views1 answer
Remove first character from string vb
VBA
0 vote227 views1 answer
Delete rows in excel vba code
VBA
0 vote229 views1 answer
How to get the value of optionbutton in vba
VBA
1 vote222 views1 answer
Random number generator vb.net
VBA
0 vote254 views1 answer
Create new worksheet excel visual basic
VBA
0 vote241 views1 answer
Return na vba
VBA
0 vote210 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote228 views1 answer
Remove series name from legendvbnet
VBA