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.
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.
