The textbox on a userform is an activeX textbox. You can place it there in
the VBE just like any other control.

You can't put a drawing toolbar textbox on a userform. You can have two
multiple acitvex controls on a userform in the same location and with the
same size and make only one visible at a time.

--
Regards,
Tom Ogilvy

"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:Oi4HReJOFHA.2384@tk2msftngp13.phx.gbl...
> Many thanks.
>
> your answer to Q2 suggests that something I've been
> looking at all weekend may be possible ... namely placing
> an ActiveX textbox on a Userform
>
> Q3 is that possible, and how?
>
> Q4 if so, can I have both a standard textbox AND an
> ActiveX textbox (both being the same size and
> occupying the same position on the Userform) and
> toggle between the two?
>
> Regards.
>
> "Tom Ogilvy" <twogilvy@msn.com> wrote in message
> news:%23XYg5GIOFHA.904@tk2msftngp13.phx.gbl...
> > 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.
> >>
> >>
> >
> >
>
>