#1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Scroll Bar Control

I need a way where I can control a macro to control some scroll bar.

I'll have about 10 - 15 scroll bar. There will be a main scroll bar. When I
move the main scroll bar the rest of the scroll bar should move according to
the main one. If the main one is at 80, then the rest should be at 80.

For the rest of the scroll bar, I should be able to adjust them different.
For example,
if I move the main scroll bar to 80, the rest will move to 80. Then I would
probably amend scroll bar 2 to 75, scroll bar 5 to 85 and so on.

Is there a way I can do that?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Scroll Bar Control

Assuming your scroll bars came from the Forms toolbar and are on a worksheet:
Assign each scroll bar's Cell Link to a different cell on the sheet. Let's
say that you assign the master scroll bar's Cell Link to cell X1, with the
other 9-14 scroll bar's linked to cells below that one (X2:X15). Then
right-click the master scroll bar and choose Assign Macro and 'New'. That
will set up a code stub for the _Change() event and you can put code like
this into it:

Sub ScrollBar1_Change()
Range("X2") = Range("X1")
Range("X3") = Range("X1")
Range("X4") = Range("X1")
'... for as many as you need
Range("X15") = Range("X1")
End Sub

That will cause all the others to move when the master changes, but still
allows the others to move independently later.

"Kim" wrote:

I need a way where I can control a macro to control some scroll bar.

I'll have about 10 - 15 scroll bar. There will be a main scroll bar. When I
move the main scroll bar the rest of the scroll bar should move according to
the main one. If the main one is at 80, then the rest should be at 80.

For the rest of the scroll bar, I should be able to adjust them different.
For example,
if I move the main scroll bar to 80, the rest will move to 80. Then I would
probably amend scroll bar 2 to 75, scroll bar 5 to 85 and so on.

Is there a way I can do that?

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) 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
Scroll bars without control tabs CJ Excel Worksheet Functions 3 August 23rd 06 12:55 AM
Scroll bar - Control Toolbox olstrain Excel Discussion (Misc queries) 1 February 3rd 06 05:52 PM
Out of control scroll lock?? Oops Excel Discussion (Misc queries) 2 January 29th 06 10:10 PM


All times are GMT +1. The time now is 05:43 PM.

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"