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

**bash** · 04-09-2013, 08:13 AM

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.

**AndyLitch** · 04-09-2013, 08:27 AM

sample2.xlsx

Originally Posted by bash

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

You can't..

Originally Posted by bash

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

**bash** · 04-09-2013, 08:30 AM

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

**Andy Pope** · 04-09-2013, 08:31 AM

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.

**AndyLitch** · 04-09-2013, 08:32 AM

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

**bash** · 04-09-2013, 09:24 AM

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?

**AndyLitch** · 04-09-2013, 09:27 AM

yep lol.

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

**Andy Pope** · 04-09-2013, 09:28 AM

Just use the activex textbox.

**bash** · 04-09-2013, 09:49 AM

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 ;-)

**Andy Pope** · 04-09-2013, 09:51 AM

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.

**bash** · 04-09-2013, 10:17 AM

Thank you Andypope.

Cheers guys, very much appreciated.

TheCaller

**bash** · 04-09-2013, 10:26 AM

Hi AndyPope.

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

Cheers.

**AndyLitch** · 04-09-2013, 10:29 AM

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

**bash** · 04-09-2013, 10:46 AM

Cheers mate.

**klawrimore** · 08-14-2017, 02:56 PM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions