camphuchia
Thành viên mới

- Tham gia
- 16/4/11
- Bài viết
- 36
- Được thích
- 7
Private Sub cmdAdd_Click()
'Dim iRow As Long: Dim ws As Worksheet'
'Set ws = Worksheets("NY")'
'iRow = ws.Cells(Rows.Count, 2).End(xlUp).Offset(1, 0).Row'
If Trim(Me.TxtPGD.Value) = "" Then
Me.TxtPGD.SetFocus
MsgBox "Vui long nhap day du", vbInformation
Exit Sub
End If
[G7].Value = Me.TxtPGD.Value
[G8].Value = Me.TxtTRUONG.Value
Me.TxtPGD.Value = ""
Me.TxtTRUONG.Value = ""
Me.TxtPGD.SetFocus
End Sub