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 vote208 views1 answer
Openfiledialog specific folder
VBA
-1 vote211 views1 answer
How to correct a number to 2 decimal places in vba
VBA
1 vote197 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote212 views1 answer
Excel vba prevent saving workbook
VBA
0 vote205 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote195 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote200 views1 answer
Vba timestamp -- milliseconds
VBA
0 vote205 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote211 views1 answer
Vba extract filename from path
VBA
0 vote221 views4 answers
How to continue formula in below line in vba code
VBA