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 vote197 views1 answer
Vba add month to date
VBA
0 vote234 views1 answer
How to enter Vbox manage commands
VBA
0 vote209 views1 answer
Sort dictionary by key vba
VBA
0 vote218 views1 answer
Thread sleep vb
VBA
3 votes197 views1 answer
Excel vba get the workbook full file name with path
VBA
8 votes328 views1 answer
Excel vba determine number of elements in a 1D array
VBA
1 vote197 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote213 views1 answer
Vbnet convert charatcer to binary
VBA
6 votes213 views1 answer
Excel vba get the path of current workbook
VBA
0 vote194 views1 answer
Backspace key has stopped working visual studio
VBA