title: object doesn't support this property or method vba
body: <p>Can anyone tell me why these lines:</p>
  
  <pre><code>Sheets("Order").Cells(orderNum, 1).Value = box.Object.Caption
  Sheets("Order").Cells(orderNum, 2).Value = box.Object.GroupName
  </code></pre>
  
  <p>are causing the error "Object doesn't support this property or method"? They seem very straightforward to me.</p>
  
  <p>Here's more of the code:</p>
  
  <pre><code>For Each box In OLEObjects
  
  box.Object.BackColor = RGB(220, 230, 241)
  
  CommandButton1.BackColor = RGB(240, 240, 240)
  CommandButton2.BackColor = RGB(240, 240, 240)
  
  TextBox1.BackColor = RGB(255, 255, 255)
  TextBox2.BackColor = RGB(255, 255, 255)
  
  'There is a very long If statement here that I'm fairly certain isn't relevant
  
  Sheets("Order").Cells(orderNum, 1).Value = box.Object.Caption
  Sheets("Order").Cells(orderNum, 2).Value = box.Object.GroupName
  
  orderNum = orderNum + 1
  
  Next
  </code></pre>