Audio equalizer type control on VBA Form

[hsk]

Hi,
I am trying to design a VBA form. The form will contain a table with 12 columns for 12 months from Jan to Dec. These columns will have certain values. And simple line graph will be drawn showing the yearly trend. This is fairly simple and I can achieve this.
Now, what I want is control on by form which will look like Audio Equalizer. A button which can be moved vertically up and down. The position of the button will determine the values in the column and the graph will be adjusted accordingly.

Anybody having any idea or solution?

 

[mjf55]

Here is a link that someone used a scroll bar and used it as you want. It looks like it might work. https://www.math.ksu.edu/~bennett/m100f06/m100slider.pdf

 

[hsk]

Thanks. I have thought of the scroll bar but it does not look very good, secondly I am having @ 24 data points so would have to draw 24 scrollbars manually.
So looking for some more sophisticated control.