Sub DanhGia
Sub DanhGia()
Dim DaDanhGia(1 To 4) As Boolean
Dim DaGhi(1 To 4) As Boolean
ReDim DaChon(1 To 4) As Boolean
10 '. Đúng màu & Đúng vị trí:
Chu = "B" & CStr(4 + iHang): Range(Chu).Select
If Mau(1) = Selection.Interior.ColorIndex Then
GhiDau "G", 1 'Sub GhiDau dùng để đánh dấu (ghi nhận) đúng KQ [O]
DaGhi(1) = -1
DaDanhGia(1) = True: DaChon(1) = -1
End If
11 Chu = "C" & CStr(4 + iHang): Range(Chu).Select
If Mau(2) = Selection.Interior.ColorIndex Then
If DaGhi(1) = 0 Then
Chu = "G": DaGhi(1) = True
ElseIf DaGhi(1) Then
Chu = "H": DaGhi(2) = True
End If
GhiDau Chu, 1
DaDanhGia(2) = True: DaChon(2) = -1
End If
12
Chu = "D" & CStr(4 + iHang): Range(Chu).Select
If Mau(3) = Selection.Interior.ColorIndex Then
If DaGhi(1) = 0 Then
Chu = "G": DaGhi(1) = -1
ElseIf DaGhi(1) Then
If DaGhi(2) = 0 Then
Chu = "H": DaGhi(2) = -1
ElseIf DaGhi(2) = -1 Then
Chu = "I": DaGhi(3) = -1
End If
End If
GhiDau Chu, 1
DaDanhGia(3) = True: DaChon(3) = -1
End If
13
Chu = "E" & CStr(4 + iHang): Range(Chu).Select
If Mau(4) = Selection.Interior.ColorIndex Then
If DaGhi(1) = 0 Then
Chu = "G": DaGhi(1) = -1
ElseIf DaGhi(1) Then
If DaGhi(2) = 0 Then
Chu = "H": DaGhi(2) = -1
ElseIf DaGhi(2) Then
If DaGhi(3) = 0 Then
Chu = "I": DaGhi(3) = -1
ElseIf DaGhi(3) Then
Chu = "J": DaGhi(4) = -1
End If
End If
End If
GhiDau Chu, 1
DaDanhGia(4) = True: DaChon(4) = -1
End If
If DaGhi(4) Then
HetVan
End If
20 '. Chỉ đúng màu & không đúng vị trí:
Chu = "B" & CStr(4 + iHang): Range(Chu).Select
If DaGhi(1) = 0 Then
For ii = 2 To 4
If Mau(ii) = Selection.Interior.ColorIndex Then
GhiDau "G", 2
DaDanhGia(ii) = -1: DaChon(1) = -1
DaGhi(1) = -1
End If
Next ii
ElseIf DaGhi(1) = -1 And DaGhi(2) = 0 And DaChon(1) = 0 Then
For ii = 2 To 4
If Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "H", 2
DaDanhGia(ii) = -1: DaChon(1) = -1
DaGhi(2) = -1
End If
Next ii
ElseIf DaGhi(2) = -1 And DaGhi(3) = 0 And DaChon(1) = 0 Then '?? ??
For ii = 2 To 4
If Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "I", 2
DaDanhGia(ii) = -1: DaChon(1) = -1
DaGhi(3) = -1
End If
Next ii
ElseIf DaGhi(3) = -1 And DaGhi(4) = 0 And DaChon(1) = 0 Then
For ii = 2 To 4
If Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "J", 2
DaDanhGia(ii) = -1: DaChon(1) = -1
DaGhi(4) = -1
End If
Next ii
End If
'!!!! Cột C
Chu = "C" & CStr(4 + iHang): Range(Chu).Select
If DaGhi(1) = 0 Then
For ii = 1 To 4
If ii <> 2 And Mau(ii) = Selection.Interior.ColorIndex Then
GhiDau "G", 2
DaDanhGia(ii) = -1: DaChon(2) = -1
DaGhi(1) = -1
End If
Next ii
ElseIf DaGhi(1) = -1 And DaGhi(2) = 0 And DaChon(2) = 0 Then
For ii = 1 To 4
If ii <> 2 And Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "H", 2
DaDanhGia(ii) = -1: DaChon(2) = -1
DaGhi(2) = -1
End If
Next ii
ElseIf DaGhi(2) = -1 And DaGhi(3) = 0 And DaChon(2) = 0 Then
For ii = 1 To 4
If ii <> 2 And Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "I", 2
DaDanhGia(ii) = -1: DaChon(2) = -1
DaGhi(3) = -1
End If
Next ii
ElseIf DaGhi(3) = -1 And DaGhi(4) = 0 And DaChon(2) = 0 Then
For ii = 1 To 4
If ii <> 2 And Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "J", 2
DaDanhGia(ii) = -1: DaChon(2) = -1
DaGhi(4) = -1
End If
Next ii
End If
'Cột D ////
Chu = "D" & CStr(4 + iHang): Range(Chu).Select
If DaGhi(1) = 0 Then
For ii = 1 To 4
If ii <> 3 And Mau(ii) = Selection.Interior.ColorIndex Then
GhiDau "G", 2
DaDanhGia(ii) = -1: DaChon(3) = -1
DaGhi(1) = -1
End If
Next ii
ElseIf DaGhi(1) = -1 And DaGhi(2) = 0 And DaChon(3) = 0 Then
For ii = 1 To 4
If ii <> 3 And Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "H", 2
DaDanhGia(ii) = -1: DaChon(3) = -1
DaGhi(2) = -1
End If
Next ii
ElseIf DaGhi(2) = -1 And DaGhi(3) = 0 And DaChon(3) = 0 Then
For ii = 1 To 4
If ii <> 3 And Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "I", 2
DaDanhGia(ii) = -1: DaChon(3) = -1
DaGhi(3) = -1
End If
Next ii
ElseIf DaGhi(3) = -1 And DaGhi(4) = 0 And DaChon(3) = 0 Then
For ii = 1 To 4
If ii <> 3 And Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "J", 2
DaDanhGia(ii) = -1: DaChon(3) = -1
DaGhi(4) = -1
End If
Next ii
End If
'Cột E ////
Chu = "E" & CStr(4 + iHang): Range(Chu).Select
If DaGhi(1) = 0 Then
For ii = 1 To 3 '4
If Mau(ii) = Selection.Interior.ColorIndex Then ' ii<>3
GhiDau "G", 2
DaDanhGia(ii) = -1: DaChon(4) = -1
DaGhi(1) = -1
End If
Next ii
ElseIf DaGhi(1) = -1 And DaGhi(2) = 0 And DaChon(4) = 0 Then
For ii = 1 To 3
If Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "H", 2
DaDanhGia(ii) = -1: DaChon(4) = -1
DaGhi(2) = -1
End If
Next ii
ElseIf DaGhi(2) = -1 And DaGhi(3) = 0 And DaChon(4) = 0 Then
For ii = 1 To 3
If Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "I", 2
DaDanhGia(ii) = -1: DaChon(4) = -1
DaGhi(3) = -1
End If
Next ii
ElseIf DaGhi(3) = -1 And DaGhi(4) = 0 And DaChon(4) = 0 Then
For ii = 1 To 3
If Mau(ii) = Selection.Interior.ColorIndex And DaDanhGia(ii) = 0 Then
GhiDau "J", 2
DaDanhGia(ii) = -1: DaChon(4) = -1
DaGhi(4) = -1
End If
Next ii
End If
DiemSo = DiemSo - 3
Range("B2").Select: ActiveCell.Value = DiemSo
Range("L" & CStr(4 + iHang)).Select
iHang = 1 + iHang: iCot = 1
End Sub