I am able to add textbox into a worksheet. but i am not able to enable
scroll bars.
I dont want the text box to autoresize to its content. How can i do
that?
what is the corresponding property to use in vba?

In Design Mode, right-click the TextBox and select Properties from the popup
menu that appears. Set the MultiLine property to True and the ScrollBar
property to whichever mode you want, then exit Design Mode.

Rick


<(E-Mail Removed)> wrote in message
news:a558d14b-752c-43d4-9ab7-(E-Mail Removed)...
>I am able to add textbox into a worksheet. but i am not able to enable
> scroll bars.
> I dont want the text box to autoresize to its content. How can i do
> that?
> what is the corresponding property to use in vba?

On Feb 9, 12:39*am, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> In Design Mode, right-click the TextBox and select Properties from the popup
> menu that appears. Set the MultiLine property to True and the ScrollBar
> property to whichever mode you want, then exit Design Mode.
>
> Rick
>
> <yajiv.vi...@gmail.com> wrote in message
>
> news:a558d14b-752c-43d4-9ab7-(E-Mail Removed)...
>
>
>
> >I am able to add textbox into a worksheet. but i am not able to enable
> > scroll bars.
> > I dont want the text box to autoresize to its content. How can i do
> > that?
> > what is the corresponding property to use in vba?- Hide quoted text -
>
> - Show quoted text -

I am using excel 2007. I dont get any multiline option or scroll bar
option.
I am getting "Format shape" and "Size and Properties" in context menu
of the text box.

You said you used a TextBox... when I select a TextBox from the ActiveX
Controls part of the dropdown panel that appears when I click the Insert
button on the Developer's tab, I end up pasting a TextBox that when I
right-click it, the Properties option is as I described. I'm guessing you
did something different to get your TextBox onto your worksheet.... can you
describe what you did to get your TextBox? By the way, the Text Field
control from the Form's section of the panel is disabled on my copy of
XL2007 (in case that is the control that you meant), but I am not sure why.

Rick


<(E-Mail Removed)> wrote in message
news:6d2a9c2d-6df7-4969-aaaa-(E-Mail Removed)...
On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> In Design Mode, right-click the TextBox and select Properties from the
> popup
> menu that appears. Set the MultiLine property to True and the ScrollBar
> property to whichever mode you want, then exit Design Mode.
>
> Rick
>
> <yajiv.vi...@gmail.com> wrote in message
>
> news:a558d14b-752c-43d4-9ab7-(E-Mail Removed)...
>
>
>
> >I am able to add textbox into a worksheet. but i am not able to enable
> > scroll bars.
> > I dont want the text box to autoresize to its content. How can i do
> > that?
> > what is the corresponding property to use in vba?- Hide quoted text -
>
> - Show quoted text -

I am using excel 2007. I dont get any multiline option or scroll bar
option.
I am getting "Format shape" and "Size and Properties" in context menu
of the text box.

There are textboxes which are simply shapes containing text, which Yajiv has
used, and there are ActiveX control textboxes, which Rick is describing.
Both are available in Excel 2007 and earlier versions.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
message news:uz%(E-Mail Removed)...
> You said you used a TextBox... when I select a TextBox from the ActiveX
> Controls part of the dropdown panel that appears when I click the Insert
> button on the Developer's tab, I end up pasting a TextBox that when I
> right-click it, the Properties option is as I described. I'm guessing you
> did something different to get your TextBox onto your worksheet.... can
> you describe what you did to get your TextBox? By the way, the Text Field
> control from the Form's section of the panel is disabled on my copy of
> XL2007 (in case that is the control that you meant), but I am not sure
> why.
>
> Rick
>
>
> <(E-Mail Removed)> wrote in message
> news:6d2a9c2d-6df7-4969-aaaa-(E-Mail Removed)...
> On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
> <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
>> In Design Mode, right-click the TextBox and select Properties from the
>> popup
>> menu that appears. Set the MultiLine property to True and the ScrollBar
>> property to whichever mode you want, then exit Design Mode.
>>
>> Rick
>>
>> <yajiv.vi...@gmail.com> wrote in message
>>
>> news:a558d14b-752c-43d4-9ab7-(E-Mail Removed)...
>>
>>
>>
>> >I am able to add textbox into a worksheet. but i am not able to enable
>> > scroll bars.
>> > I dont want the text box to autoresize to its content. How can i do
>> > that?
>> > what is the corresponding property to use in vba?- Hide quoted text -
>>
>> - Show quoted text -
>
> I am using excel 2007. I dont get any multiline option or scroll bar
> option.
> I am getting "Format shape" and "Size and Properties" in context menu
> of the text box.

Thanks for posting that. I don't play with shapes much, so I'm not sure I
ever saw that there is a TextBox one of them. A quick look makes it seem
that scroll bars are not an option with this version of the TextBox. I would
guess that the OP will need to use an ActiveX TextBox in order to get the
scroll bars he seeks.

Rick


"Jon Peltier" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> There are textboxes which are simply shapes containing text, which Yajiv
> has used, and there are ActiveX control textboxes, which Rick is
> describing. Both are available in Excel 2007 and earlier versions.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
> message news:uz%(E-Mail Removed)...
>> You said you used a TextBox... when I select a TextBox from the ActiveX
>> Controls part of the dropdown panel that appears when I click the Insert
>> button on the Developer's tab, I end up pasting a TextBox that when I
>> right-click it, the Properties option is as I described. I'm guessing you
>> did something different to get your TextBox onto your worksheet.... can
>> you describe what you did to get your TextBox? By the way, the Text Field
>> control from the Form's section of the panel is disabled on my copy of
>> XL2007 (in case that is the control that you meant), but I am not sure
>> why.
>>
>> Rick
>>
>>
>> <(E-Mail Removed)> wrote in message
>> news:6d2a9c2d-6df7-4969-aaaa-(E-Mail Removed)...
>> On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
>> <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
>>> In Design Mode, right-click the TextBox and select Properties from the
>>> popup
>>> menu that appears. Set the MultiLine property to True and the ScrollBar
>>> property to whichever mode you want, then exit Design Mode.
>>>
>>> Rick
>>>
>>> <yajiv.vi...@gmail.com> wrote in message
>>>
>>> news:a558d14b-752c-43d4-9ab7-(E-Mail Removed)...
>>>
>>>
>>>
>>> >I am able to add textbox into a worksheet. but i am not able to enable
>>> > scroll bars.
>>> > I dont want the text box to autoresize to its content. How can i do
>>> > that?
>>> > what is the corresponding property to use in vba?- Hide quoted text -
>>>
>>> - Show quoted text -
>>
>> I am using excel 2007. I dont get any multiline option or scroll bar
>> option.
>> I am getting "Format shape" and "Size and Properties" in context menu
>> of the text box.
>
>

A note to the OP...

I'm going to guess that you do not (yet) have a Developer tab on your
Ribbon. You can put it there by clicking the Office button (the large, round
one in the top left corner), click the Excel Options button at the bottom of
the display that appears, put a check mark in the "Show Developer tab in the
Ribbon" check box under the "Top options for working with Excel" section
and, finally, click OK. You will now have a Developer tab where you can
select the ActiveX version of the TextBox after clicking the Insert button
in the Controls panel.

Rick


"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Thanks for posting that. I don't play with shapes much, so I'm not sure I
> ever saw that there is a TextBox one of them. A quick look makes it seem
> that scroll bars are not an option with this version of the TextBox. I
> would guess that the OP will need to use an ActiveX TextBox in order to
> get the scroll bars he seeks.
>
> Rick
>
>
> "Jon Peltier" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> There are textboxes which are simply shapes containing text, which Yajiv
>> has used, and there are ActiveX control textboxes, which Rick is
>> describing. Both are available in Excel 2007 and earlier versions.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> Peltier Technical Services, Inc. - http://PeltierTech.com
>> _______
>>
>>
>> "Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote
>> in message news:uz%(E-Mail Removed)...
>>> You said you used a TextBox... when I select a TextBox from the ActiveX
>>> Controls part of the dropdown panel that appears when I click the Insert
>>> button on the Developer's tab, I end up pasting a TextBox that when I
>>> right-click it, the Properties option is as I described. I'm guessing
>>> you did something different to get your TextBox onto your worksheet....
>>> can you describe what you did to get your TextBox? By the way, the Text
>>> Field control from the Form's section of the panel is disabled on my
>>> copy of XL2007 (in case that is the control that you meant), but I am
>>> not sure why.
>>>
>>> Rick
>>>
>>>
>>> <(E-Mail Removed)> wrote in message
>>> news:6d2a9c2d-6df7-4969-aaaa-(E-Mail Removed)...
>>> On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
>>> <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
>>>> In Design Mode, right-click the TextBox and select Properties from the
>>>> popup
>>>> menu that appears. Set the MultiLine property to True and the ScrollBar
>>>> property to whichever mode you want, then exit Design Mode.
>>>>
>>>> Rick
>>>>
>>>> <yajiv.vi...@gmail.com> wrote in message
>>>>
>>>> news:a558d14b-752c-43d4-9ab7-(E-Mail Removed)...
>>>>
>>>>
>>>>
>>>> >I am able to add textbox into a worksheet. but i am not able to enable
>>>> > scroll bars.
>>>> > I dont want the text box to autoresize to its content. How can i do
>>>> > that?
>>>> > what is the corresponding property to use in vba?- Hide quoted text -
>>>>
>>>> - Show quoted text -
>>>
>>> I am using excel 2007. I dont get any multiline option or scroll bar
>>> option.
>>> I am getting "Format shape" and "Size and Properties" in context menu
>>> of the text box.
>>
>>
>

On Feb 10, 1:05*am, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> A note to the OP...
>
> I'm going to guess that you do not (yet) have a Developer tab on your
> Ribbon. You can put it there by clicking the Office button (the large, round
> one in the top left corner), click the Excel Options button at the bottom of
> the display that appears, put a check mark in the "Show Developer tab in the
> Ribbon" check box under the "Top options for working with Excel" section
> and, finally, click OK. You will now have a Developer tab where you can
> select the ActiveX version of the TextBox after clicking the Insert button
> in the Controls panel.
>
> Rick
>
> "Rick Rothstein (MVP - VB)" <rick.newsNO.S...@NO.SPAMverizon.net> wrote in
> messagenews:(E-Mail Removed)...
>
>
>
> > Thanks for posting that. I don't play with shapes much, so I'm not sure I
> > ever saw that there is a TextBox one of them. A quick look makes it seem
> > that scroll bars are not an option with this version of the TextBox. I
> > would guess that the OP will need to use an ActiveX TextBox in order to
> > get the scroll bars he seeks.
>
> > Rick
>
> > "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com> wrote in message
> >news:(E-Mail Removed)...
> >> There are textboxes which are simply shapes containing text, which Yajiv
> >> has used, and there are ActiveX control textboxes, which Rick is
> >> describing. Both are available in Excel 2007 and earlier versions.
>
> >> - Jon
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Tutorials and Custom Solutions
> >> Peltier Technical Services, Inc. -http://PeltierTech.com
> >> _______
>
> >> "Rick Rothstein (MVP - VB)" <rick.newsNO.S...@NO.SPAMverizon.net> wrote
> >> in messagenews:uz%(E-Mail Removed)...
> >>> You said you used a TextBox... when I select a TextBox from the ActiveX
> >>> Controls part of the dropdown panel that appears when I click the Insert
> >>> button on the Developer's tab, I end up pasting a TextBox that when I
> >>> right-click it, the Properties option is as I described. I'm guessing
> >>> you did something different to get your TextBox onto your worksheet.....
> >>> can you describe what you did to get your TextBox? By the way, the Text
> >>> Field control from the Form's section of the panel is disabled on my
> >>> copy of XL2007 (in case that is the control that you meant), but I am
> >>> not sure why.
>
> >>> Rick
>
> >>> <yajiv.vi...@gmail.com> wrote in message
> >>>news:6d2a9c2d-6df7-4969-aaaa-(E-Mail Removed)....
> >>> On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
> >>> <rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> >>>> In Design Mode, right-click the TextBox and select Properties from the
> >>>> popup
> >>>> menu that appears. Set the MultiLine property to True and the ScrollBar
> >>>> property to whichever mode you want, then exit Design Mode.
>
> >>>> Rick
>
> >>>> <yajiv.vi...@gmail.com> wrote in message
>
> >>>>news:a558d14b-752c-43d4-9ab7-(E-Mail Removed)....
>
> >>>> >I am able to add textbox into a worksheet. but i am not able to enable
> >>>> > scroll bars.
> >>>> > I dont want the text box to autoresize to its content. How can i do
> >>>> > that?
> >>>> > what is the corresponding property to use in vba?- Hide quoted text-
>
> >>>> - Show quoted text -
>
> >>> I am using excel 2007. I dont get any multiline option or scroll bar
> >>> option.
> >>> I am getting "Format shape" and "Size and Properties" in context menu
> >>> of the text box.- Hide quoted text -
>
> - Show quoted text -

I had Developer tab. But just missed that toolbox. Now I am ready.
Superb responses.Thanks a lot!