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

6 votes234 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote223 views1 answer
Vba get application version
VBA
1 vote223 views1 answer
Excel vba saveas force overwrite
VBA
0 vote221 views1 answer
Vba full date format
VBA
0 vote230 views1 answer
Vb.net visible property dgv collumn not working
VBA
8 votes306 views1 answer
Vba make integer
VBA
0 vote210 views1 answer
Open application from vbnet
VBA
0 vote218 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote219 views3 answers
Write to text file vb.net
VBA
0 vote244 views1 answer
Delete all controls in an area vb
VBA