title: How to pass multiple arguments to procedure in VBA?
body: <p>I am trying to pass two string parameters to a Sub, but its not allowing me do that. The approach I have used is given below. </p>
  
  <pre><code>Sub callByValue( str1 As String, str2 As String)
  MsgBox str1
  MsgBox str2
  
  End Sub
  </code></pre>
  
  <p>Calling Macros:</p>
  
  <pre><code> Dim s1, s2 As String
   callByValue(s1,s2)
  </code></pre>
  
  <p>While calling <code>callByvalue</code>, it's throwing a compiler error.</p>