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

Рет қаралды 64,451

11 жыл бұрын

📊 Free Workbooks: www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)
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:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbaisfun.com/contact/

Пікірлер: 39

@bloodwolf2609 2 жыл бұрын

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 4 жыл бұрын

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

@ExcelVbaIsFun 10 жыл бұрын

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 5 жыл бұрын

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 5 жыл бұрын

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

@paulolopes5714 4 жыл бұрын

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 !

@adriano.santana 6 жыл бұрын

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

@ExcelVbaIsFun 6 жыл бұрын

Wow! I'm so glad it helped!

@chunyuling 5 жыл бұрын

really really good!!!Thank you!

@esbi1124 4 жыл бұрын

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

@ExcelVbaIsFun 4 жыл бұрын

Glad it helped

@samkwamedaniel895 4 жыл бұрын

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.

@ExcelVbaIsFun 11 жыл бұрын

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

@ilyasikm 4 жыл бұрын

Which version of this excel?

@Don0mer 9 жыл бұрын

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

@hetleerhuis-destadskerk9847 5 жыл бұрын

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 8 жыл бұрын

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

@pradeepvishwakarma9831 3 жыл бұрын

hi... thanks.. its very helpful

@eduardoreinaux5150 6 жыл бұрын

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!

@andreaaccetta5697 6 жыл бұрын

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 5 жыл бұрын

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

@ahamadalthaf279 4 жыл бұрын

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

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

@casterMobile Жыл бұрын

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

@AaAbid-sp5rd 2 жыл бұрын

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?

@professorlanguagepartners3112 3 жыл бұрын

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 ?

@dad135 2 жыл бұрын

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

@waynexw. 3 жыл бұрын

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

@sridharkrishnappanavanerth3388 5 жыл бұрын

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 5 жыл бұрын

Sure! Try this video please: kzfaq.info/get/bejne/rK2XqLCK0qfIj5c.html Thanks Dan