Private Sub CommandButton1_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("DATA")
iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
If Trim(Me.TextBox2.Value) = "" Then
Me.TextBox2.SetFocus
MsgBox "Ma nhan vien khong duoc de trong ", vbCritical + vbOKOnly
Exit Sub
End If
ws.Cells(iRow, 1).Value = Me.TextBox1.Value
ws.Cells(iRow, 2).Value = Me.TextBox2.Value
ws.Cells(iRow, 3).Value = Me.TextBox3.Value
ws.Cells(iRow, 4).Value = Me.TextBox4.Value
ws.Cells(iRow, 5).Value = Format(Me.TextBox5.Value, "DD/MM/YYYY")
ws.Cells(iRow, 6).Value = Me.TextBox6.Value
ws.Cells(iRow, 7).Value = Me.TextBox7.Value
ws.Cells(iRow, 8).Value = Format(Me.TextBox8.Value, "DD/MM/YYYY")
ws.Cells(iRow, 9).Value = Me.TextBox9.Value
ws.Cells(iRow, 10).Value = Me.TextBox10.Value
ws.Cells(iRow, 11).Value = Me.TextBox11.Value
ws.Cells(iRow, 12).Value = Me.TextBox12.Value
ws.Cells(iRow, 13).Value = Me.TextBox13.Value
ws.Cells(iRow, 14).Value = Me.TextBox14.Value
ws.Cells(iRow, 15).Value = Format(Me.TextBox15.Value, "DD/MM/YYYY")
ws.Cells(iRow, 16).Value = Me.TextBox16.Value
ws.Cells(iRow, 17).Value = Format(Me.TextBox17.Value, "DD/MM/YYYY")
ws.Cells(iRow, 18).Value = Me.TextBox18.Value
ws.Cells(iRow, 19).Value = Me.TextBox19.Value
ws.Cells(iRow, 20).Value = Me.TextBox20.Value
ws.Cells(iRow, 21).Value = Me.TextBox21.Value
ws.Cells(iRow, 22).Value = Me.TextBox22.Value
ws.Cells(iRow, 23).Value = Me.TextBox23.Value
ws.Cells(iRow, 24).Value = Me.TextBox24.Value
ws.Cells(iRow, 25).Value = Me.TextBox25.Value
ws.Cells(iRow, 26).Value = Me.TextBox26.Value
ws.Cells(iRow, 27).Value = Format(Me.TextBox27.Value, "DD/MM/YYYY")
ws.Cells(iRow, 28).Value = Format(Me.TextBox28.Value, "DD/MM/YYYY")
ws.Cells(iRow, 29).Value = Format(Me.TextBox29.Value, "DD/MM/YYYY")
ws.Cells(iRow, 30).Value = Me.TextBox30.Value
Me.TextBox1.Value = ""
Me.TextBox2.Value = ""
Me.TextBox3.Value = ""
Me.TextBox4.Value = ""
Me.TextBox5.Value = ""
Me.TextBox6.Value = ""
Me.TextBox7.Value = ""
Me.TextBox8.Value = ""
Me.TextBox9.Value = ""
Me.TextBox10.Value = ""
Me.TextBox11.Value = ""
Me.TextBox12.Value = ""
Me.TextBox13.Value = ""
Me.TextBox14.Value = ""
Me.TextBox15.Value = ""
Me.TextBox16.Value = ""
Me.TextBox17.Value = ""
Me.TextBox18.Value = ""
Me.TextBox19.Value = ""
Me.TextBox20.Value = ""
Me.TextBox21.Value = ""
Me.TextBox22.Value = ""
Me.TextBox23.Value = ""
Me.TextBox24.Value = ""
Me.TextBox25.Value = ""
Me.TextBox26.Value = ""
Me.TextBox27.Value = ""
Me.TextBox28.Value = ""
Me.TextBox29.Value = ""
Me.TextBox30.Value = ""
End Sub
Private Sub CommandButton2_Click()
Unload Me
End Sub
Private Sub TextBox5_AfterUpdate()
TextBox5 = Format(Me.TextBox5.Value, "DD/MM/YYYY")
End Sub
Private Sub TextBox8_AfterUpdate()
TextBox8 = Format(Me.TextBox8.Value, "DD/MM/YYYY")
End Sub
Private Sub TextBox15_AfterUpdate()
TextBox15 = Format(Me.TextBox15.Value, "DD/MM/YYYY")
End Sub
Private Sub TextBox17_AfterUpdate()
TextBox17 = Format(Me.TextBox17.Value, "DD/MM/YYYY")
End Sub
Private Sub TextBox27_AfterUpdate()
TextBox27 = Format(Me.TextBox27.Value, "DD/MM/YYYY")
End Sub
Private Sub TextBox28_AfterUpdate()
TextBox28 = Format(Me.TextBox28.Value, "DD/MM/YYYY")
End Sub
Private Sub TextBox29_AfterUpdate()
TextBox29 = Format(Me.TextBox29.Value, "DD/MM/YYYY")
End Sub