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