Scroll bar (control) doesn't scroll!! ???

[Guest]

Hi there. I have a scroll bar control in cell G84 that I need to scroll up
and down the E81 cell which is a merged cell consisting of E81:F83.

Is the scroll bar not working because it is a merged cell?

What can I do to make the scroll bar scroll up and down within that E81 cell
that has a lot of typed text?

It is not a protected sheet or locked cell.

 

[NickHK]

It would seems you do not understand the purpose of a ScrollBar control.
It returns/sets a numeric value in its .LinkedCell property.
It does not scroll text in a cell.

If this is not what you are trying to achieve, then post back.

Use a text box maybe, or enlarge the cell(s) to show all text.

NickHK

 

[Guest]

I think of a scroll bar much like any other scroll bar you use in
applications or on the web to scroll up and down a page. Does excel not have
something like this?

I do not want to just enlarge the cell because there is a lot of text in it
and I want the box to stay small and just scroll if you need to see the text
at the end.

Is that possible?

 

[NickHK]

No, you will have to rethink your approach.
You can link the cell to a text box, which you can scroll.

NickHK