multiple argument subs vba
I add this answer, for Why your syntax works with one argument ?
Public Sub setInterest(account As String) '...somecode...End SubsetInterest ("myAccount")
Note :
When there is not any,
between(
and)
, VBA thinks it's a formula and exactly one argument.
When formula calculate the result will be like this:
Dim str As Stringstr = ("TEST")Debug.Print str[Output:]TEST