How to insert a scroll bar in an individual cell

[Questions?]

Hi guys,
I am an intern at a company and am using a lot of Excel for the first time. My boss suggested this website, so I hope you guys can help me out. I need to make a scroll bar to scroll within one cell. I am assuming the cells above and below the chosen cell would be frozen. Any ideas?
Thanks!

 

[whiskycan]

Hi Questions, I'm just wondering what kind of info you have in the cells that it would need a scrollbar for and how many cells would you need to build this in to? I believe it could be done but it would be very complex, especially if you're new to Excel. A potentially easier solution would be to make the cells larger and turn word wrap on. Even a Userform might be a better way to go if you have a lot of text in each cell.

 

[Legacy 98055]

My first thought would be to place a texbox in the cell, set MultiLine=True, WordWrap=True, EnterKeyBehavior=True, ScrollBars=fmScrollBarsVertical. Size the textbox to the same dimensions as the cell. See the download for an example...

<a href="http://home.fuse.net/tstom/0618080009.325219.zip"><img src="http://home.fuse.net/tstom/zip.gif"width="16"height="16"border="0"></a> <a href="http://home.fuse.net/tstom/0618080009.325219.zip">0618080009.325219.zip</a>

 

[Amish]

Hi right Click ! Can u explain more in detail about procdure ! since i am new to excel

 

[Legacy 98055]

http://www.google.com/search?hl=en&q=How+do+I+insert+a+textbox+on+an+Excel+worksheet%3F

 

[Amish]

Hi !

I was able to put textbox in cell , but i wanted procedure in detail after that step.

 

[Legacy 98055]

See video. Need ShockWave Flash to view.

<a href="http://home.fuse.net/tstom/061908.325219.swf.html"><img src="http://home.fuse.net/tstom/zip.gif"width="16"height="16"border="0"></a> <a href="http://home.fuse.net/tstom/061908.325219.swf.html">061908.325219.swf.html</a>