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


wrote in message
...
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\)"
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

wrote in message

...



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


wrote in message
...
On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
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

wrote in message

...



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)" wrote in
message ...
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


wrote in message
...
On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
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

wrote in message

...



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" wrote in message
...
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)" wrote in
message ...
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


wrote in message
...
On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
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

wrote in message

...



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)" wrote in
message ...
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" wrote in message
...
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)" wrote
in message ...
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


wrote in message
...
On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
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

wrote in message

...



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\)"
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)" wrote in
. ..



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" wrote in message
...
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)" wrote
in l...
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

wrote in message
....
On Feb 9, 12:39 am, "Rick Rothstein \(MVP - VB\)"
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

wrote in message

....

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! :)