Excel VBA Forms Part 9 - Spin Buttons

[@ricardosantos7884]

Amazing !!! Thank you for these series about forms, Andrew !!! I've been learned a lot !!!

[@nuhzakir8896]

End of the video was great.Thank you.

[@edrianmanuel6527]

More Power WiseOwl Thanks for TUT 5 star for this !

[@edrianmanuel6527]

+WiseOwlTutorials for next tutorials can you make your voice volume up pls. ☺TIA

[@edrianmanuel6527]

+WiseOwlTutorials for next tutorials can you make your voice volume up pls. ☺TIA

[@krn14242]

Thanks... loved the progress bar example.

[@divyal5852]

Loved it, Andrew!!!

[@victoropere2107]

best tutorials ever

[@kumar-manoj]

Great video sir, thank you so much 🙏

[@WiseOwlTutorials]

Thank you Manoj, happy to hear you enjoyed it!

[@stephenhammond1745]

Just watching this video playlist now. Very helpful. One issue I found with using the textbox_change event to synchronize the spinbutton is that in entering a number in the valid range you can enter invalid numbers. Eg. If my spinbutton range is 10 to 100, then when I try to enter a number like 20, as soon as I type the first digit 2, I get the 'out of range' error message. This is because the change event fires every time anything is typed into the textbox and 2 is less than the minimum value. Is there a way to stop this other than using some other event like Exit or AfterUpdate?

[@WiseOwlTutorials]

Hi! I'd use a different event as you suggest, or just lock the text box so it can't be typed into!

[@stephenhammond1745]

@@WiseOwlTutorials I used the exit event. I just don't know whether there is some drawback to using that. Anyway, not a major issue...I just populate the spinbutton values using a different method that doesn't involve changing the range.

[@WiseOwlTutorials]

@@stephenhammond1745 I can't think of any drawback - it sounds like a sensible option to me!

[@stephenhammond1745]

@@WiseOwlTutorials Ok. Thanks. One last question if I may. I have a loop where I need to go one row down and one column over from a anchor cell. I do this with Offset. I then need to select and total the column I've selected. So, code looks like: Range("a1").offset(1,1) , Range("a1").offset(1,1).end(xldown)... hope I didn't make any typos. I'm trying to give that as an argument to the SUM() function but keep getting syntax error (I think because of the embedded ",".) Is there some way this could work? I get around it by setting a Range variable and using that in the SUM ()function. Hope this is clear. Thanks

[@WiseOwlTutorials]

@@stephenhammond1745 Hi! Sure, just put the same code you use to populate the range variable into the sum function, this works: Debug.Print WorksheetFunction.Sum(Range(Range("A1").Offset(1, 1), Range("A1").Offset(1, 1).End(xlDown))) Hope it helps!