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

3 votes278 views1 answer
Vba make long from two shorts
VBA
27 votes401 views2 answers
Vba check if file exists
VBA
0 vote291 views1 answer
Vbnet hex to binary
VBA
0 vote372 views1 answer
Vba vbcrlf chr
VBA
0 vote279 views1 answer
Vba word pdf table to excel
VBA
0 vote276 views1 answer
Vba DisplayGridlines
VBA
2 votes268 views1 answer
Vba uppercase first letter of each word
VBA
0 vote272 views1 answer
Check if program is running vbnet
VBA
0 vote289 views1 answer
Vbscript check if string is empty
VBA
18 votes422 views2 answers
Vba make word from bytes
VBA