Excel VBA ActiveX Series #5 SpinButton - Incrementing and decrementing a cells number, Move controls

Spin buttons have either a Vertical orientation or a horizontal orientation. One spin button contains two arrows, either up/down or left/right. Using the SpinUp/SpinDown events in our example, we can control the value of our cell, variable or any applicable number. Give this one a try!

Fantastic Developer Tools:

[bloodwolf]

The fact that this is the most useful tutorial for this function that I could find and it’s 8 years old is amazing.

[darkspace]

Awesome! Exactly what I wanted. Couldn't find it anywhere!

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[paulolopes]

I have been searching for a way to add a count button to an excel spreadsheet for a long time, and finally I have found... your video ! THANKS A LOT !

[bpurch]

Only a simple video but that's all i needed. Really really good as I could have gone own a rabbit hole working this out. Cheers!

[adriano.santana]

Thanks a lot, man. Solved the doubts I was having in a matter of minutes.

[esbi]

Hello. Short, easy and clear. Thanks a lot.

[ExcelVbaIsFun]

Hmmm, great stuff, sir! Thanks for the comments!

[dad]

After adding the range code, I click on the button but it still appears the VBA code., not display number? What should I do?

[anhnhatnguyet]

When click one random cell with data in cell is number, auto appear spin button to add or subtract active cell 1 unit, use vba, can do it ?

[eduardoreinaux]

Hello! Quick question - Each time I click on the button, it seems to lose resolution... up to the point where I can't see the little black arrows within the spin button. Any idea why that is? Thanks!

[AaAbid-sprd]

Hi Dear, Thanks for the video. I have a quarry. If I want to make .6=1, it increases like .1, .2, .3, .4, .5 when it's .6 it makes 1.0. like and next Stape is 2 in one cell? how can I make it?

[casterMobile]

How do you transfer FROM a cell TO another cell with each click?

[samkwamedaniel]

Thanks very much for tutorials, I like to know if there is a way to make just a cell behave as a normal calculator.
i.e this cell should be capable of summing figures that appears in another cell, while keeping last cumulative figure visible.
This other cell will be the key-in cell or active cell.
Example:
Cell 1: =2*5, Answer appears in Cell 2,
Cell 1: =3*6.8, Answer is added to the previous value resulting from (2*5) and still appears in cell 2.

[professorlanguagepartners]

I'm a rookie. Silly question. Wouldn't blocking the cell prevent an error by not allowing the user to type anything in cell and force them to only use spin buttons ?

[waynexw.]

If I want to link the cell to any mouse click cell, I do not know how to do

[andreaaccetta]

Thank you a lot for this tutorial!

Do you know if this buttons could change the value of the selected cell instead of a fixed cell?
For example I have a stock list with 80 items and it would be great to have only one button to incr./decr. instead of one for every row.

[hetleerhuis-destadskerk]

Someone got the - first spin button function - for me in an excel sheet to download? I can't use the developer on my computer. I need it asap. Thank you!

[VTOLmad]

Tried the basic increment a cell by 1, saved in macro enabled but didnt work. Checked typing multiple times, nada. Closed workbook & reopened, that was worse as everything was greyed out in the tool bar, Im stuck, any help gratefully accepted :)

[Donmer]

Hello, how do u make limits at that macro :S? max 2 and min 1 ? :S