title: Accessing ActiveX control from Module
body: <p>I guess I have my basic wrong here, can anybody please correct me?</p>
  
  <p>I have an ActiveX control in "home" worksheet. Now, when I code, </p>
  
  <p><strong>This works:</strong></p>
  
  <pre><code>MsgBox (ThisWorkbook.Worksheets("home").quantity.Value)
  </code></pre>
  
  <p><strong>So does this:</strong></p>
  
  <pre><code>With ThisWorkbook.Worksheets("home")
      MsgBox (.quantity.Value)
  End With
  </code></pre>
  
  <p><strong>But this does not:</strong></p>
  
  <pre><code>Dim wh As Worksheet
  Set wh = ThisWorkbook.Worksheets("home")
  MsgBox (wh.quantity.Value)
  </code></pre>
  
  <p>Can anybody please explain the difference?</p>