How to insert a scroll bar in an individual cell

W

whiskycan

New Member

Joined

Jun 16, 2008

Messages

18

• Jun 17, 2008

• #2

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.

 

Upvote 0

L

Legacy 98055

Guest

• Jun 18, 2008

• #3

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>

 

Upvote 0

A

Amish

New Member

Joined

Jun 15, 2008

Messages

24

• Jun 18, 2008

• #4

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

 

Upvote 0

L

Legacy 98055

Guest

• Jun 18, 2008

• #5

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

 

Upvote 0

A

Amish

New Member

Joined

Jun 15, 2008

Messages

24

• Jun 19, 2008

• #6

Hi !

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

 

Upvote 0

L

Legacy 98055

Guest

• Jun 19, 2008

• #7

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>

 

Upvote 0