Assigning Min and Max Values to Dependent Scroll Bars

[hgteros]

Hi all,

I am totally new to VBA so please be patience with me first. Thanks.

In this project, I want to devide a string of scores (RawData sheet) into three bands, say Red, Yellow, and Green. I'd like to have the ability to change the cut scores for each band so I set up 2 scroll bars for two cut scores (see attached file). I know that there are several people have asked the similar question about assigning values to scroll bars but I could not make it work after trying several alternatives. My apology if it has be solved before.

What I want to do is set the minimum value of the 1st bar to be the minimum score in the string and the maximum score of the 1st bar to the minimum score of the 2nd bar. For the 2nd bar, I want to set its minium value to the maximum value of the first bar and the maximum value of the 2nd bar to the maximum value of the string.

Thanks a lot. I really appreciate your help.

Best,

t

[hgteros]

Hi all,

I am still in need for the code. Please help!

Thanks,
t

[Andy Pope]

Use the cells O2:P2 to store min/max values for first scrollbar.
Use the cells P4 to store max values for second scrollbar.

Right click sheet tab and click View Code.
paste this code in sheet code module.

Please Login or Register  to view this content.

Your explanation of what the min/max values should be does not make sense. The 2nd Min = 1st Max which is = 2nd Min. You need to define 1 before the other can be the same value.

The above code will not work if O2:P2 and P4 are based on formula.

[hgteros]

Thanks Andy. Sorry for delaying in response to this. I found another way around this but your code may be very useful in the future as I worked with these bars a lot.