title: VBA: Calling a sub on another worksheet with multiple arguments
body: <p>I've been struggling for a while to call a procedure (sub) with arguments that is located on another worksheet. I can call a procedure on another worksheet. I can call a procedure with arguments. But combining the two causes me headache's.</p>
  
  <p>Here's what I have now: </p>
  
  <pre><code>Private Sub Workbook_Open()
  Call Sheet2.FillCombo("Mngt Dashboard", "ComboMonth")
  'Sheet2.FillCombo"Operational Dashboard", "ComboMonth2"
  End Sub
  </code></pre>
  
  <p>I tried both syntaxis for calling the procedure but both result in 'subscript out of range (9)'.
  Here's the procedure being called (located on sheet2):</p>
  
  <pre><code>Sub FillCombo(SheetName As String, ObjName As String)
  Dim objCombo As Object
  Set objCombo = ActiveWorkbook.Sheets(SheetName).OLEObjects(ObjName).Object
  objCombo.Clear
  objCombo.AddItem.....
  ...
  End Sub
  </code></pre>
  
  <p>Is there anyone out there that can show me the light? </p>
  
  <p>Thanks in advance, Mark</p>