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?