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

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.

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

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

"worksfire1" wrote in message
...
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.

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

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

NickHK

"worksfire1" wrote in message
...
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" wrote:

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

"worksfire1" wrote in message
...
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.