How to automatically go thorough a scroll bar range

[Keano100]

I haven't a clue how to do this and don't know if this is even possible. I'm trying to learn how to create a dashboard and have a scroll bar which links to a table and populates with a different chart whenever the scroll bar is clicked.

I would like the scroll bar to go through its full range automatically and I thought I could record a macro to do this. However, I have been searching various forums and cant find an answer. I'm a newbie when it comes to macros so any help would be appreciated

[Andy Pope]

One way is simply to change the value of the linked cell.

[Keano100]

Cheers Andy, you are a genius. One small favour though. Is there a quick way to make it loop back to the start again? I can copy the code again to do this but it will become cumbersome to do this all the time.

[Keano100]

Andy, I think I solved it. Bit of reading on loops and then a bit of guesswork. I initially put Do while 1ngIndex < 11 but it didnt work so I changed it to Do While Range("C3") < 11 and I think its fine now. Thanks for your help.

[Andy Pope]

This one will scroll until the button is pressed again.