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...

[@2chandra]

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

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

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

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

[@5adamjb]

Great stuff Dan. Thank you.

[@ExcelVbaIsFun]

Very welcome!

[@WorldFactsFast]

it helped me. thanks buddy

[@ExcelVbaIsFun]

Thats great news!! Dan

[@ExcelVbaIsFun]

Thank you!

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

[@krn14242]

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

[@PiXpilot_Shridhar]

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!

[@farebeka]

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

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

[@maxg2595]

helped a lot thanks

[@ExcelVbaIsFun]

Dateight bit guy so glad it helped!!