Excel VBA ActiveX 13 Spin Button to Go Up or Down the Combobox List

In this lesson, we show you how to go up or down a combobox or list using a spin button. If you click up, the previous entry in the dropdown will show, if you click the down arrow, the next entry. . .

We also review how to avoid problems and control the limits of the top range and the bottom range. Because nobody wants to see an error screen! Check it out!

Fantastic Developer Tools:

[QuantumIdeas]

Awesome! I was looking around for a spinwheel numeric input in excel and this gave me the appropriate answer. Smashed the like button...

[michaelhays]

Cheers Dan just what me looking for

You Da Man

[kevincunha]

I loved it! Can it work with links? So instead of months, there would appear links that i could click?

[ExcelVbaIsFun]

Excellent question - i'll have to make a video on that topic. Yes, davidbuaron, ListIndex is an index number between 0 and however many items (rows) there are in the list. List count shows the count of how many items (rows) there are. More on this later i gotta make a bottle for the baby. Thanks Dan

[esbi]

Hi it was really useful, thanks a lot.

[davidbuaron]

As usual great video.can you please explain the difference between list index to list count?

[clifordfrancillon]

Thank you so much bro! that really helped

[krn]

Dan, thanks. Question, was I the inspiration for this video?

[ExcelVbaIsFun]

I'm not sure, very possibly. Someone had a comment on one of my vids a couple days ago that was going on about spin buttons and comboboxes and I thought some people may want to use them together. Was that you, krn? Probably. Thanks!!
Dan

[VamsiBharadwajReddy]

Hi, can I use text box instead of combo box .. will it work the same ? Please help

[dikky]

can you help me sir, in this video you use Combo Box and what if we use Data Validation with Spin Button, can u help me sir how to use Spin Button with Data Validation sir??