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 vote213 views1 answer
Vba loop through textboxes
VBA
0 vote232 views1 answer
Vba get relative cell address
VBA
0 vote208 views1 answer
Excel vba hide columns
VBA
0 vote248 views1 answer
Iterate all file in a folder vba
VBA
1 vote237 views1 answer
Change the first item in a queue vb.net
VBA
0 vote223 views1 answer
Get current url vb.net
VBA
0 vote236 views1 answer
VBA
VBA
1 vote230 views1 answer
Extract the second word in a text in excel
VBA
0 vote229 views1 answer
Excel filter by date not working vba
VBA
4 votes228 views1 answer
Excel vba determine number of elements in an array
VBA