title: Reference a check box in another open workbook
body: <p>I am trying to refer to the value of an ActiveX checkbox control in another worksheet. My goal is to make the value of the check box in my current workbook the same as the one in another open workbook.</p>
  
  <p>I can do this between two checkboxes in the same workbook on different sheets:</p>
  
  <pre><code>Private Sub CommandButton1_Click()
  
  If Sheets("Sheet2").Box2.Value = True Then
      Box1.Value = True
  Else: Box1.Value = False
  End If
  
  End Sub
  </code></pre>
  
  <p>But I'm receiving a Run-time error '9' "Subscript out of range" error when I run the following code:</p>
  
  <pre><code>Private Sub CommandButton2_Click()
  
  If Worksheets("Book2").OLEObjects("Box3").Value = True Then
      Box1.Value = True
  Else: Box1.Value = False
  End If
  </code></pre>
  
  <p>End Sub</p>
  
  <p>The "If Worksheets" line is highlighted when I try to debug the code. I'm sure I'm referring to the other checkbox incorrectly, but I've searched high and low for the proper way to refer to this without any luck. Thank you in advance for your help!</p>