Hi

1st try to use the scroll bar from Control Toolbox rather than Form toolbar,
because it provide more flexibility for programming. After dragging the
first and 2nd toolbars then right-click it view code, you will see the it
event sub of Scrollbar1_change()

if you want the scrollbar 2 change the same value as scrhollbar 1 change, so
add below code:

Me.ScrollBar2.value = scrollbar1.value

So everytime you change scrollbar1 then scrollbar 2 will change accordingly.

hope this help.

Leung



"Scott from Gippsland" wrote:

Hi,

I am developing a questionare in excel, and require the users to select an
answer based on a scroll bar, ranging from 1 -100. I have 5 questions, each
with its own scrollbar, which in total need to add up to 100.

Is it possible with VB to enable the scroll bars to automatically adjust so
that when one is changed, the others change accordingly.

Any assistance would be greatly appreciated.

Scott