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 vote240 views1 answer
How to get the value of optionbutton in vba
VBA
4 votes248 views1 answer
VBA Deep Clone Dictionary
VBA
0 vote245 views1 answer
Loop through lines in text file vb net
VBA
0 vote250 views1 answer
For each item in folder outlook vba
VBA
0 vote228 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote250 views1 answer
Vba character ascii code
VBA
0 vote227 views1 answer
Remove last 8 characters from string vb
VBA
0 vote232 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote254 views1 answer
Vba remove the first character of string
VBA
0 vote226 views1 answer
Vba sheet visible
VBA