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 vote286 views1 answer
Vba code to remove leading and trailing spaces
VBA
1 vote396 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote365 views1 answer
Power query M substract minimum value of column -dax
VBA
6 votes396 views1 answer
Excel vba check if a string only contains alpha characters
VBA
25 votes488 views2 answers
Excel vba folder exist
VBA
1 vote385 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
1 vote342 views1 answer
Vba compile error object required
VBA
0 vote352 views1 answer
Backspace key has stopped working visual studio
VBA
8 votes391 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote338 views1 answer
Vba add month to date
VBA