Excel VBA USERFORMS #17 Increase and Decrease Dates in Textbox with Spinbutton

📊 Free Workbooks: www.excelvbais...
🥷Join Excel Ninja Pro: www.excelvbais... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbais... (Free downloads, Trainings, Live Q&A and more)
Click up, increases one day. Down decreases date by one day. Easy!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbais... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbais...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbais...

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

[@silentflight1]

Great stuff, I used it not for date but simply for increasing and decreasing the value in a textbox using a spinbutton. I was initially using the "on change" trigger and was having difficulties!

[@ExcelVbaIsFun]

Good work! Glad this helped you, my friend!
Dan

[@JuanGarnicaVera]

I have this spin button on my userForm. It works good only one time. When i open the user form a second time the spin button starts over from the minimun value. How can i make it to retain the last value in order to move it from there?
Thank you.

[@vmazz5618]

Dan, you have made a semi-pro VBAer out of me. The spin button help was spot on. Have one on me. Thanks

[@2chandra]

Great Stuff!!!!!!! It helped me to improve my project since date picker is not available in excel 2010

[@maheshkumarsm147]

I would like to add rows when spin up button is pressed when spin down button is rows could be deleted please provide the code for this

[@ExcelVbaIsFun]

Very welcome!

[@5adamjb]

Great stuff Dan. Thank you.

[@pulse_sonic]

It helped me lot...thank you dear....
Actually my use is start date is today's date and end date will be previous date ... And start date should take system dates...
Any how I got an idea

[@bengtlee28]

This worked for me too. Thanks to him!

[@ExcelVbaIsFun]

Thank you!

[@WorldFactsFast]

it helped me. thanks buddy

[@krn14242]

Wow, I must be learning, cause I caught yr error before you tried it. Thanks Dan.

[@ExcelVbaIsFun]

Thats great news!! Dan

[@farebeka]

it did help!!!!!!! thank U!!

[@maxg2595]

helped a lot thanks

[@ExcelVbaIsFun]

Dateight bit guy so glad it helped!!

[@bengtlee28]

THANK YOU SO MUCH!

[@bengtlee28]

I actually used your codes to a different setting. If my textbox1(date1) change, my textbox2(date2) will change date too and add 6 days. So my date range will cover 7 days which will be a week. Thank you, sir!

[@ExcelVbaIsFun]

That's awesome!!