Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scroll Bar Control Kim Excel Discussion (Misc queries) 1 December 4th 09 12:22 PM
Scroll bar (control) doesn't scroll!! ??? worksfire1 Excel Worksheet Functions 2 June 28th 07 02:18 PM
Scroll bar control doesn't scroll !! ??? worksfire1 Setting up and Configuration of Excel 0 June 27th 07 07:52 PM
Control Scroll bar mcroozer Excel Programming 1 December 24th 05 03:44 AM
Scroll horizontaly with mouse, create same system used to scroll . frederic New Users to Excel 5 October 9th 05 08:15 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"