Using spin buttons to control a Dropdown List.

[lukmanayahayya1]

Good Morning all.

Please I need your help on how to use spin buttons to control a dropdown list in Excel.

If its possible, please guide me on how to do it. It's gonna mean alot to me.



Thanks.

 

[6StringJazzer]

Please provide a lot more information about what you want to do.

A spin button moves a value up or down, one increment at a time on each click.

A dropdown list is...a list. I assume you are talking about a cell with data validation using a list. If not please explain further.

How do you want a spin button to control a list?

 

[lukmanayahayya1]

Please provide a lot more information about what you want to do.

A spin button moves a value up or down, one increment at a time on each click.

A dropdown list is...a list. I assume you are talking about a cell with data validation using a list. If not please explain further.

How do you want a spin button to control a list?

I have a data validation(which is a dropdown list) in a cell. I want to use the spin buttons to move the values up or down, one increment at a time.

 

[6StringJazzer]

A lot more information.

What are the values, how are they populated into the list, and what values do you want to go up or down? All of the values in the whole list? What increment do you want to use? Default is 1 but you can set it to anything.

 

[lukmanayahayya1]

A lot more information.

What are the values, how are they populated into the list, and what values do you want to go up or down? All of the values in the whole list? What increment do you want to use? Default is 1 but you can set it to anything.

A lot more information.

What are the values, how are they populated into the list, and what values do you want to go up or down? All of the values in the whole list? What increment do you want to use? Default is 1 but you can set it to anything.

Yes, that's exactly what I mean.
The values in there are list of names.
If I have A to Z, and I selected D, I want whenever I press the spin up, the value in the cell just becomes E, or spindown to become C.
I hope you get the explanatiom

 

[6StringJazzer]

It sounds like once you select a value from the list, you want to be able to use the spin button to change that selected value to the next one above or below it in the list.

I will ask one more time--I'm really having trouble getting the information I need.

What are the values, how are they populated into the list

 

[lukmanayahayya1]

It sounds like once you select a value from the list, you want to be able to use the spin button to change that selected value to the next one above or below it in the list.

I will ask one more time--I'm really having trouble getting the information I need.

That is exactly what I meant.

 

[lukmanayahayya1]

It sounds like once you select a value from the list, you want to be able to use the spin button to change that selected value to the next one above or below it in the list.

I will ask one more time--I'm really having trouble getting the information I need.

Yes Sir. This is all I meant.

 

[lukmanayahayya1]

Please use the following link to get the sample file Loading Google Sheets

Thanks alot.

 

[6StringJazzer]

This requires VBA.

Spin button on a dropdown List_093822.xlsm

Shared with Dropbox

www.dropbox.com