+ Reply to Thread
Results 1 to 15 of 15

How do i add a scrollbar to a cell which has a huge amount of text in it?

  1. #1
    Registered User
    Join Date
    09-06-2007
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    23

    How do i add a scrollbar to a cell which has a huge amount of text in it?

    Hi all.

    Firstly, please excuse me if this question has been asked. "How do i add a scrollbar to a cell which has a hug amount of text in it?"

    I could not find anything exact as my query. I am not versed in VBA, so i am a noob.

    I have a lot of text which i want to paste into a cell in excel, then have a scrollbar attached to this cell, so that i can scroll the text.

    I have been reading about the form control scrollbar, but cannot find information on how to use it for text. All the information i have read, seems to be on how to manipulate numbers.

    Is it possible to have a scrollbar attached to a cell with lots of text in it? Or do i need a text box?

    Please can someone advise on the best way to achieve this?

    Thanks in advance.
    Last edited by bash; 04-09-2013 at 08:21 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    sample2.xlsx

    Quote Originally Posted by bash View Post
    "How do i add a scrollbar to a cell which has a hug amount of text in it?"
    You can't..

    Quote Originally Posted by bash View Post
    Is it possible to have a scrollbar attached to a cell with lots of text in it? Or do i need a text box?
    A textbox is made for the job and you can link it to a cell in the properties
    Last edited by AndyLitch; 04-09-2013 at 08:31 AM.
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    09-06-2007
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    23

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    Hi AndyLitch.

    I appreciate your reply.

    Being an excel novice, would it be possible for you to instruct me on how i can add a text box, and attach a scroll bar to it please?

    Thanks in advance.

    TheCaller

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,926

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    You would need to use an activeX textbox control. Use the LinkedCell property to populate it.
    Set the Multiline and Wordwrap properties to True. Enable Vertical scrollbar.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    I've attached a sample file to my original post..

  6. #6
    Registered User
    Join Date
    09-06-2007
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    23

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    AndyLitch, i had a look at your sample excel, but to be honest i am not sure how i can amend it for what i need? Sorry I'm a complete noob. :-( I don't know where to paste my text and where the scrollbar is?

    AndyPope, i tried the following, please correct me if i am wrong.

    1. i placed a horizontal text box on the worksheet.
    2. in the developer option, i selected the activex scroll bar.
    3. i placed the scroll bar on top of the text box.
    4. in the properties of the scrollbar, i only see LinkedCell (there are no multiline, wordwrap, vertical scrollbar options).
    5. Do i add my text in LinkedCell, or just the cell value e.g F6?

    I am probably doing this totally incorrectly. Not sure where to go from here?

    Sorry!

    BTW i am using Microsoft Excel 2007, if this helps?

  7. #7
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    yep lol.

    the textbox scrollbar appears automatically in the textbox when there is overspill.... i linked the textbox in the example to cell a100

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,926

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    Just use the activex textbox.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    09-06-2007
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    23

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    Thanks AndyLitch. Kind of made heads and tails of it now. very much appreciated mate.

    AndyPope
    Is there a way to reposition and resize the textbox pls?
    Also, there is text in the cell B3, can i not delete this, or is this text directly linked to the scrollbox? Ideally, i would like to see only the textbox on the worksheet.

    Once again, thanks to both AndyLitch and AndyPope ;-)

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,926

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    You need to be in Design Mode. Developer tab > Design mode.

    You can either hide the cell or link to a cell on another sheet.

  11. #11
    Registered User
    Join Date
    09-06-2007
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    23

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    Thank you Andypope.

    Cheers guys, very much appreciated.

    TheCaller

  12. #12
    Registered User
    Join Date
    09-06-2007
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    23

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    Hi AndyPope.

    Sorry, one last thing - How do i link to a cell on another sheet pls?

    Cheers.

  13. #13
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    in the properties linked cell it should read 'Sheet 1'!A1

  14. #14
    Registered User
    Join Date
    09-06-2007
    Location
    Southampton
    MS-Off Ver
    Office 365
    Posts
    23

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    Cheers mate.

  15. #15
    Registered User
    Join Date
    08-14-2017
    Location
    SC
    MS-Off Ver
    2010
    Posts
    1

    Re: How do i add a scrollbar to a cell which has a huge amount of text in it?

    Hey everyone,

    I'm new - and i know this post is old...
    I'm using Excel 2010 and am having some problems getting this to work.

    I've tried using the ActiveX Textbox and have done the following for the properties:

    excel help.png

    I've tried linking H4 - the cell i'm trying to get to scroll, with no luck. The contents of the cell will appear in the text box, but i'm not able to scroll up or down.

    I've also tried the ActiveX Scroll bar and have the following for the properties:

    excel help2.png

    it won't let me link H4 - I get an invalid property value error.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1