Spin Button to Increase or Decrease the Time by 30 minutes - Excel VBA

📊 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)
Learn to use a spin button with increasing the time of day by 30 min or decreasing it! check it out!!
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/

[@jamessmyth]

Very cool! Outstanding video, and I love spin buttons - thanks to you your video's I use them often...

[@ExcelVbaIsFun]

James Smyth Dude! Awesome. so glad you enjoy using them. Yep they're pretty useful at times.

[@tjparty]

If you want to display to display just time with out the date. Hide Textbox1 and Display TextBox2 beside the spinners and format Me.TextBox2 = Format(Me.TextBox1, "HH:mm AMPM") then you will display time but use the format in Textbox1 to calculate properly.

[@jezjoseph9461]

How would you add this time to a cell?

[@fizz113]

ExcelVbaIsFun How do you transfer the spin button to an Excel worksheet?

[@QuanPham-lm9pf]

Thank you.

[@ExcelVbaIsFun]

+Quan Pham Very welcome!

[@cd-ux9ot]

maybe if mytime >= 1 then mytime = mytime-1 ?

[@tjparty]

You know you could have skipped all that logical (IF then) if you had set the text box value up properly under
Private Sub UserForm_Initialize()
TextBox1 = Now
End Sub
Then the DateAdd will act properly.
You really should understand what you are trying to teach first.