Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I'm currently having trouble trying to link two scrollbars that are part of different frames on the same multitab of a form. Basically, when one scrolls up/down, I want the other one to scroll up/down accordingly (and for this to be invisible to the user). My main problem is probably not being able to access any of the properties of the scrollbars themselves. I've tried capturing the ScrollBar1_Change event, but nothing happens. I've tried the following code to at least loop through them all so I have some names to work off, but it doesn't like the For Each line (object doesn't support this property or method error): Sub ScrollFinder() Dim myScroll As ScrollBar For Each myScroll In WeightForm MsgBox myScroll.Name Next End Sub How do I access the scrollbars that are part of a frame? I've tried working through the objects (e.g. WeightForm.Tabs.AMTab.AMAppTab.AMAppFrame2.ScrollB ar1.Name) but none of it seems to work. Are there issues with programmatically changing scrollbars that are part of a frame/multitab? Many thanks for any help you can offer, Ross. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Synching worksheets in same workbook | Excel Discussion (Misc queries) | |||
Hyperlinks break when synching from Pocket Excel | Links and Linking in Excel | |||
synching two lists | Excel Programming | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
Scrollbar | Excel Programming |