title: Excel VBA Run-time error '424': Object Required when trying to copy TextBox
body: <p>I'm attempting to copy the contents of a text box from one <code>workbook</code> to another.  I have no problem copying cell values from the first <code>workbook</code> to the 2nd, but I get an <code>object required</code> error when I attempt to copy the text box.  This <code>macro</code> is being run from the workbook containing the data I want copied.  Using <code>Excel 2007</code> Code:</p>
  
  <pre><code>Sub UploadData()
      Dim xlo As New Excel.Application
      Dim xlw As New Excel.Workbook
      Set xlw = xlo.Workbooks.Open("c:\myworkbook.xlsx")
      xlo.Worksheets(1).Cells(2, 1) = Range("d4").Value 'Copy cell content (this works fine)
      xlo.Worksheets(1).Cells(2, 2) = TextBox1.Text 'This gives me the object required error
      xlw.Save
      xlw.Close
      Set xlo = Nothing
      Set xlw = Nothing
  End Sub
  </code></pre>
  
  <p>Thanks for any help.</p>