How to add a text box with scroll bars in excel 2007?

[yajiv.vijay]

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?

 

[Rick Rothstein \(MVP - VB\)]

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

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






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

 

[Rick Rothstein \(MVP - VB\)]

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

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






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

 

[Jon Peltier]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[yajiv.vijay]

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

message



- Show quoted text -

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