VBA Code for TextBox & SpinButton To set Time Format

[Malcolm torishi]

Hi can anyone tell me if it’s possible to have a two TextBox 1&2 with two SpinButton 1&2 that sits in a userform so when the user presses the SpinButton 1 it drops a time format into say cell A1which would be known as leave and by pressing SpinButton 2 it drops a time format into say cell A2 which would be known as return . Also can the leave TextBox 1 , when the user form is open, be set at the know time.
Thank you

 

[My Aswer Is This]

Put these three scripts in your UserForm:

Private Sub SpinButton1_Change()
'Modified  8/7/2019  2:57:00 PM  EDT
Cells(1, 1).Value = Format(Time, "HH:MM:SS")
End Sub
Private Sub SpinButton2_Change()
'Modified  8/7/2019  2:57:00 PM  EDT
Cells(2, 1).Value = Format(Time, "HH:MM:SS")
End Sub
Private Sub UserForm_Initialize()
'Modified  8/7/2019  2:57:00 PM  EDT
TextBox1.Value = Format(Time, "HH:MM:SS")
End Sub

 

[Malcolm torishi]

Thank you that helps me so much

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thank you that helps me so much