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

2 votes114 views1 answer
Excel vba pause
VBA
5 votes178 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote154 views1 answer
Vba word pdf table to excel
VBA
0 vote174 views1 answer
Vba simple quote
VBA
0 vote169 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
5 votes182 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote165 views1 answer
Remove last 8 characters from string vb
VBA
0 vote177 views1 answer
Vba paste values
VBA
0 vote161 views1 answer
Vb check if row has column
VBA
3 votes165 views1 answer
Excel vba make long from two shorts
VBA