[RESOLVED] Adding scroll bar on Excel Text Box

[VB22]

Hello all,

I've had a good look around, but can't seem to find a solution.

All I want to do is add a scroll bar onto a Text Box I've drawn in Excel. I've read somewhere that you can set this via the properties window - but when I highlight the Text Box then fgo to properties, I see the properties for the whole sheet rather than just the Text Box.

Any help would be much appreciated.

James

[Siddharth Rout]

1) Please specify Excel Version
2) Are you placing the textbox on a worksheet?
3) How have you created the textbox?

From menu View~~>Toolbars~~>Control toolbox?

Or

From menu View~~>Toolbars~~>Forms ?

[VB22]

Hi koolsid, thanks for your reply

1) I am using Excel 2003

2) I am placing the textbox directly on the worksheet

3) I was actually drawing the textbox on the worksheet using View~~>Toolbars~~>Drawing.

In actual fact, I've solved my problem now! I have just used View~~>Toolbars~~>Control toolbox to add my textbox, and can now edit the properties of it no problem, including adding a vertical scroll bar.