Private Sub CommandSave_Click()
Dim intline, r1, r2 As Integer
Dim f As Long
Dim w As String
r1 = (Left(ComboBox3.Value, 2) - Left(ComboBox2.Value, 2))
r2 = (Right(ComboBox3.Value, 2) - Right(ComboBox2.Value, 2))
If r1 < 0 Then r1 = 23 + r1
If r2 < 0 Then r2 = 60 + r2
'save data on the sheet
Application.ScreenUpdating = False
With Sheets("data")
intline = .Range("A10000").End(xlUp).Row + 1
.Range("a" & intline).Value = DateValue(TextBoxDate.Value)
.Range("b" & intline).Value = ComboBox2.Text
.Range("c" & intline).Value = ComboBox3.Text
r1 = (Left(ComboBox3.Value, 2) - Left(ComboBox2.Value, 2))
r2 = (Right(ComboBox3.Value, 2) - Right(ComboBox2.Value, 2))
If r1 < 0 Then r1 = 23 + r1
If r2 < 0 Then r2 = 60 + r2
.Range("d" & intline).Value = r1 & ":" & r2
.Range("e" & intline).Value = ComboBox1.Text
.Range("f" & intline).Value = TextBoxCOMMENTAIRE.Text
Sheets("acasa").Select
MsgBox "Date salvate"
End With
Application.ScreenUpdating = True
Unload UserForm1
Load welcome
welcome.Show
End If
End If
End Sub