Results 1 to 7 of 7

How to insert a scroll bar in an individual cell

This is a discussion on How to insert a scroll bar in an individual cell within the Excel Questions forums, part of the Question Forums category; Hi guys, I am an intern at a company and am using a lot of Excel for the first time. ...

  1. #1
    New Member
    Join Date
    Jun 2008
    Posts
    1

    Default How to insert a scroll bar in an individual cell

    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!

  2. #2
    New Member
    Join Date
    Jun 2008
    Posts
    18

    Default Re: How to insert a scroll bar in an individual cell

    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.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824

    Default Re: How to insert a scroll bar in an individual cell

    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...

    0618080009.325219.zip

  4. #4
    New Member
    Join Date
    Jun 2008
    Posts
    24

    Default Re: How to insert a scroll bar in an individual cell

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

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824

    Default Re: How to insert a scroll bar in an individual cell


  6. #6
    New Member
    Join Date
    Jun 2008
    Posts
    24

    Default Re: How to insert a scroll bar in an individual cell

    Hi !

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

  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824

    Default Re: How to insert a scroll bar in an individual cell

    See video. Need ShockWave Flash to view.

    061908.325219.swf.html

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com