Variable Maximums for Scroll Bars

[muzunova]

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.

 

[muzunova]

Seems I forgot to provide the attachment. Sorry, here's a link to the file:

Scroll bar