Private Sub TxtDiem_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
If TxtDiem = "" Or IsNumeric(TxtDiem) = False Then
MsgBox "Ky qua", , "Ptm0412"
Exit Sub
End If
Dim Diem As Double
If Opt1 Then
If Val(TxtDiem) = 10 Or Len(TxtDiem) = 1 Then
Diem = Val(TxtDiem)
Else
Diem = Val(TxtDiem) / IIf(Len(TxtDiem) = 3, 100, 10)
End If
Cells(1000, 3).End(xlUp).Offset(1).Value = Diem
TxtDiem = ""
Cancel = True
Else
If Val(TxtDiem) = 10 Or Len(TxtDiem) = 1 Then
Diem = Val(TxtDiem)
Else
Diem = Val(TxtDiem) / IIf(Len(TxtDiem) = 3, 100, 10)
End If
Range(RefCell).Value = Diem
TxtDiem = ""
Cancel = True
End If
End Sub