Textbox questions

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.

Yes to both.
1) Do you mean a textbox on a userform? Copying is straightforward:
UserForm1.TextBox1 = Sheets("Sheet1").OLEObjects("TextBox1").Object.Value
Forms toolbar does not allow me (in XP) to create a textbox on a sheet - If
you mean a textbox from the drawing toolbar, then to get the text (left side
of above equation) it would be:
Sheets("Sheet1").Shapes("Text Box 1").TextFrame.Characters.Text
If it is indeed a Forms control (earlier version of Excel?) then it would be:
Sheets("Sheet1").Shapes("TextBox1").ControlFormat.Value

2) Again, assuming you are talking about a Userform, any control has a top,
left, height and width property that you can use to set size and position, in
points. You can do the same with Shape objects on a worksheet (including
both the forms controls and ActiveX controls, since both are "contained" in a
Shape).

"Stuart" wrote:

> 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.
>
>
>

Many thanks for the help.
Will post back if problems remain.

Regards.

"K Dales" <KDales@discussions.microsoft.com> wrote in message
news:EA733DDB-5846-4938-8B9F-D3F2F02F417B@microsoft.com...
> Yes to both.
> 1) Do you mean a textbox on a userform? Copying is straightforward:
> UserForm1.TextBox1 = Sheets("Sheet1").OLEObjects("TextBox1").Object.Value
> Forms toolbar does not allow me (in XP) to create a textbox on a sheet -
> If
> you mean a textbox from the drawing toolbar, then to get the text (left
> side
> of above equation) it would be:
> Sheets("Sheet1").Shapes("Text Box 1").TextFrame.Characters.Text
> If it is indeed a Forms control (earlier version of Excel?) then it would
> be:
> Sheets("Sheet1").Shapes("TextBox1").ControlFormat.Value
>
> 2) Again, assuming you are talking about a Userform, any control has a
> top,
> left, height and width property that you can use to set size and position,
> in
> points. You can do the same with Shape objects on a worksheet (including
> both the forms controls and ActiveX controls, since both are "contained"
> in a
> Shape).
>
> "Stuart" wrote:
>
>> 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.
>>
>>
>>

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.
>
>

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.
>>
>>
>
>

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.
> >>
> >>
> >
> >
>
>

Thanks for clearing up my confusion.
Regards.

"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:ed9ZAMKOFHA.3704@TK2MSFTNGP12.phx.gbl...
> 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.
>> >>
>> >>
>> >
>> >
>>
>>
>
>