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.