Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim D1, D2, D3, Rng As Range
Set Rng = Range("todo01, todo02, todo03")
If Intersect(Target, Rng) Is Nothing Then Exit Sub
Cancel = True
Application.ScreenUpdating = False
On Error Resume Next
If ActiveCell.Column > 1 And ActiveCell.Column < 9 Then
1 If ActiveCell.Column = 3 Then
ActiveCell.Offset(0, -1).Range("A1").Select
ElseIf ActiveCell.Column = 4 Then
ActiveCell.Offset(0, -2).Range("A1").Select
ElseIf ActiveCell.Column = 5 Then
ActiveCell.Offset(0, -3).Range("A1").Select
ElseIf ActiveCell.Column = 6 Then
ActiveCell.Offset(0, -4).Range("A1").Select
ElseIf ActiveCell.Column = 7 Then
ActiveCell.Offset(0, -5).Range("A1").Select
ElseIf ActiveCell.Column = 8 Then
ActiveCell.Offset(0, -6).Range("A1").Select
D1 = ActiveCell.Row
2 End If
'<=|'
30 If ActiveCell <> 1 Then
Dim TB
TB = MsgBox("CHON: [YES] THEM, [NO] XOA!", vbYesNoCancel, "THEM/XOA DANH MUC SAN PHAM!")
If TB = vbYes Then
[Todo_F1].Copy
Range("B" & D1).Select
ActiveCell.Range("A1:G1").Insert Shift:=xlDown
ElseIf TB = vbNo Then
ActiveCell.Range("A1:G1").Delete Shift:=xlUp
End If
31 End If
ActiveCell.Offset(1, 2).Range("A1").Select
End If
If ActiveCell.Column > 9 And ActiveCell.Column < 15 Then
4 If ActiveCell.Column = 11 Then
ActiveCell.Offset(0, -1).Range("A1").Select
ElseIf ActiveCell.Column = 12 Then
ActiveCell.Offset(0, -2).Range("A1").Select
ElseIf ActiveCell.Column = 13 Then
ActiveCell.Offset(0, -3).Range("A1").Select
ElseIf ActiveCell.Column = 14 Then
ActiveCell.Offset(0, -4).Range("A1").Select
D2 = ActiveCell.Row
5 End If
32 If ActiveCell <> 1 Then
Dim tb2
tb2 = MsgBox("CHON: [YES] THEM, [NO] XOA!", vbYesNoCancel, "THEM/XOA DANH MUC SAN PHAM!")
If tb2 = vbYes Then
[Todo_F2].Copy
Range("J" & D2).Select
ActiveCell.Range("A1:E1").Insert Shift:=xlDown
ElseIf tb2 = vbNo Then
ActiveCell.Range("A1:E1").Delete Shift:=xlUp
End If
33 End If
ActiveCell.Offset(1, 2).Range("A1").Select
End If
If ActiveCell.Column > 15 And ActiveCell.Column < 21 Then
6 If ActiveCell.Column = 17 Then
ActiveCell.Offset(0, -1).Range("A1").Select
ElseIf ActiveCell.Column = 18 Then
ActiveCell.Offset(0, -2).Range("A1").Select
ElseIf ActiveCell.Column = 19 Then
ActiveCell.Offset(0, -3).Range("A1").Select
ElseIf ActiveCell.Column = 20 Then
ActiveCell.Offset(0, -4).Range("A1").Select
D3 = ActiveCell.Row
7 End If
34 If ActiveCell <> 1 Then
Dim tb3
tb3 = MsgBox("CHON: [YES] THEM, [NO] XOA!", vbYesNoCancel, "THEM/XOA DANH MUC SAN PHAM!")
If tb3 = vbYes Then
[Todo_F3].Copy
Range("P" & D3).Select
ActiveCell.Range("A1:E1").Insert Shift:=xlDown
ElseIf tb3 = vbNo Then
ActiveCell.Range("A1:E1").Delete Shift:=xlUp
End If
35 End If
ActiveCell.Offset(1, 2).Range("A1").Select
End If
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub