1. don't think you need to use copy. Just assign.

worksheets("Sheet1").Textboxes("Text Box 1").Text = _
Userform1.Textbox1.Text

If you run into problems with string length, then you can use the characters
method to transfer the string 255 characters at a time.

2. The activeX textbox is positioned relative to the top left corner of the
userform, so the top and left properties should do it.

--
Regards,
Tom Ogilvy



"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:%238H3iiBOFHA.4000@TK2MSFTNGP10.phx.gbl...
> 2 questions, please:
>
> 1. Can I copy the contents of an ActiveX textbox on a
> sheet to a textbox created from the forms toolbar?
>
> 2. Can I establish (in points) the top left corner of the
> form's textbox, relative to the top left corner of the
> form itself?
>
> Regards.
>
>