Is it possible to assign a range to a "Spin Button"?

[Shinod]

Is it possible to assign a range to a "Spin Button"? I mean Switching the data with reference to a specific range?

I have data validation in cell "A2" with "B2:B8" and i want to switch the values clicking this button. Is that Possible?

Thanks in Advance.

 

[6StringJazzer]

There might be a way to achieve your ultimate goal but it would be better to describe that goal rather than how you imagine it might be done. For example, a better approach might be to use formulas in B2:B8 based on the spin button value, rather than using the spin button to indicate a totally different range for data validation.

What determines the values you want to use for data validation, and what are they?