Public Check As BooleanOption Explicit
Private Sub Worksheet_Activate()
additemcombo
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Target
If .Row > 11 And .Column = 3 And .Count = 1 Then
ComboBox1.Activate
With ComboBox1
.Value = ""
.Top = Target.Top
.Visible = True
End With
Else
ComboBox1.Visible = False
End If
End With
End Sub
Private Sub ComboBox1_Change()
Dim ws As Worksheet, Found As Range
If ActiveCell.Row > 11 And Sheet3.ComboBox1 <> "" Then
For Each ws In ThisWorkbook.Worksheets
With ws
If ws.Name = "HD BAN HANG" Then Exit Sub
Set Found = .Range("D12:D50000").Find(ComboBox1.Value)
If Not Found Is Nothing Then
'Sheet HD BAN HANG Cot C12 tro xuong "Chu y offset (,2)"
ActiveCell.Offset(, 0).Value = Found.Offset(, 0).Value
'Sheet HD BAN HANG Cot H12 tro xuong
ActiveCell.Offset(, 5).Value = Found.Offset(, 15).Value
'Sheet HD BAN HANG Cot F12 tro xuong
ActiveCell.Offset(, 3).Value = Found.Offset(, 7).Value
'Sheet HD BAN HANG Cot E12 tro xuong
ActiveCell.Offset(, 2).Value = Found.Offset(, 3).Value
'Sheet HD BAN HANG Cot D12 tro xuong
ActiveCell.Offset(, 1).Value = Found.Offset(, 2).Value
'Sheet HD BAN HANG Cot B12 tro xuong
ActiveCell.Offset(, -1).Value = Found.Offset(, -1).Value
'Sheet HD BAN HANG Cot A12 tro xuong
ActiveCell.Offset(, -2).Value = Application.WorksheetFunction.CountA(Range("C12:C" & ActiveCell.Row))
Exit For
End If
End With
Next ws
End If
End Sub
Private Sub ComboBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Sheet3.ComboBox1.DropDown
End Sub
Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
'Hide combo box and move to next cell on Enter and Tab
Select Case KeyCode
Case 9 'tab key
ActiveCell.Offset(0, 1).Activate
Case 13 'enter key
ActiveCell.Offset(1, 0).Activate
Case 37 'left
ActiveCell.Offset(0, -1).Activate
Case 39 'right
ActiveCell.Offset(0, 1).Activate
Case 46 ' delete key
' Me.ComboBox1.DropDown
' Case 38
' ActiveCell.Offset(-1).Activate
' Case 40
' ActiveCell.Offset(1).Activate
End Select