Variable Maximums for Scroll Bars

Greetings,

Apologies for asking about something which is probably quite easy, but I'm a complete newbie to VBA and am still trying to learn.

I have to set four Scroll Bars which are conditional on each other, i.e. when a user scrolls on one of them (a percentage figure), the maximums of the other three immediately recalculate to reflect this - their maximums become 100 (%) - the scrolled value.

I have attached an excel sheet with just these elements, because the total file is quite big and mixed up. I know that the Scroll Bar shapes have to be tweaked through VBA so that their maximum values are set to the four values in Column E (E4:E7), but I have no idea how to do that... Sorry, would be grateful if someone can help.

Thanks.

Assign the same macro, SetScroller , to all the scroll bars.

Please Login or Register  to view this content.

You can put code in the change event of each control

For scrollbar1

Please Login or Register  to view this content.