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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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?
 
No, you will have to rethink your approach.
You can link the cell to a text box, which you can scroll.

NickHK
 
Back
Top