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

[@bloodwolf2609]

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

[@darkspace3316]

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

[@paulolopes5714]

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 !

[@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

[@bpurch4358]

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!

[@ExcelVbaIsFun]

So glad it helped, Ben. Thanks for the comment!

[@esbi1124]

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

[@ExcelVbaIsFun]

Glad it helped

[@adriano.santana]

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

[@ExcelVbaIsFun]

Wow! I'm so glad it helped!

[@professorlanguagepartners3112]

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 ?

[@ExcelVbaIsFun]

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

[@ilyasikm]

Which version of this excel?

[@samkwamedaniel895]

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.

[@dad135]

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

[@casterMobile]

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

[@anhnhatnguyet4628]

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 ?

[@AaAbid-sp5rd]

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 1.1,1.2,.................1.5 and next Stape is 2 in one cell? how can I make it?

[@chunyuling]

really really good!!!Thank you!

[@eduardoreinaux5150]

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!

[@pradeepvishwakarma9831]

hi... thanks.. its very helpful

[@andreaaccetta5697]

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.

[@piski12]

I am looking for the same thing. Did you figoure that out? Thanks

[@ahamadalthaf279]

did you figure out a solution for this ? Would be great if you can share.

[@waynexw.]

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

[@khaledgaber5312]

It's not working do you have any advice?

[@hetleerhuis-destadskerk9847]

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!

[@sridharkrishnappanavanerth3388]

sir i am trying to do a inventory system using user forms, i have a text box for invoice number. we use our standard practice format as "SN-2019-0001" and then increments by 1 ie it will be "SN-2019-0002" etc. how can i do this using excel vba. please can you make a video with a example.

[@ExcelVbaIsFun]

Sure! Try this video please: kzbin.info/www/bejne/rHjKpoCPoqaXlcU Thanks Dan

[@sdoblack365]

Why my Excel show me text comile error: Invalid use of property

[@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 :)

[@Don0mer]

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

[@lholhofox]

YOU ARE A F$#%@ GENIUS!!! THANK YOU!

[@ExcelVbaIsFun]

Wow! Thanks, Leonardo, I'm sure you are too, my friend! Happy coding!

[@lholhofox]

Cheers!