Use a scrollbar to select a value between any two given numbers

Hi all

I've been unable to find a solution using a scroll bar where you can scroll between two random variable numbers.

So, I've created one which has taken some thought with a bit of trial and error. It's a simple sheet, but everything is available on the sheet

You'll need to understand how Name Manager works as this is how the drop down system work. This is tagged as B. It uses the filter system to filter. It's simple enough to copy and paste into most projects as it only picks up information from three areas

The scrollbar value is 200 which is why there is also 200 within the formula to, so don't alter these as this is part of the percentage +100 0 -100 solution

There is no VBA coding either as I didn't want to use it as its part of a much larger project I'm working playing with

Please find the code attached

I hope it helps someone in the future

Cheers, Bounce

Bounce-Sliderbar.xlsx

Thank you for posting this. I have updated your title to more fully describe what you are doing.

Although using Name Manager to name the range used to populate the dropdown is a nice solution, it is not required. You can put the range reference directly into the dropdown definition.

You are not scrolling between random numbers, you are scrolling between arbitrary numbers. That is, there is nothing that randomly selects two numbers, but your solution will work for any two numbers no matter what they are.

Ha, my meaning regarding the random number parts was that you could add any numbers into the two fields which populate from the drop down. But in thinking, I’ve not tried it with negative numbers, so my wording might be entirely correct

But, I’ll clarify it with

It will work with any random number you input manually so long as the first inputted number is smaller than the second inputted number”

You don’t even need to use the name manager, that’s just how I need it to work and was how it was tested 

Enjoy all!

Just noticed your name, you have 6 Strings in it! My uncle started a very popular facebook group many years ago which is still going strong today. I’m guessing with that name, you’re a guitars looker too

Cheers for changing and moving it where it needs, I must admit, I was a little lost on what to call it or where to place it 👍

Cheers, Bounce

What's the name of the Facebook group? I am in a few guitar-related groups.