How to create scroll bars in text box

[Guest]

I want to add a scroll bar to an inserted text box within a worksheet to scroll down the text inside instead of a long text box. How to do this ? I appreciate any help.

 

[Harald Staff]

Hi

Use one from the Controls toolbox and set its Scrollbars property to the
desired one(s).

--
HTH. Best wishes Harald
Followup to newsgroup only please

I want to add a scroll bar to an inserted text box within a worksheet to

scroll down the text inside instead of a long text box. How to do this ? I
appreciate any help.

 

[carrimw]

Hi

I am having the same difficulties as ~x was, but it seems that th
solution wasn't located in this thread. If any of you would be able t
post the solution that would be very helpful. Thanks in advance.

This has been a very helpful site so far as I work my way throug
excel

 

[Dave Peterson]

First, the original post/thread has aged off my message list.

But if you created a textbox from the control toolbox toolbar (not the Drawing
toolbar), then you can

show that control toolbox
click on the design mode icon
rightclick on the textbox
select properties
scroll down to: scrollbars and set them for horizontal/vertical or both.
Set Multiline to true
and then play around with the wordwrap property (so you can set it the way you
want)