Option Explicit
'==============
Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
An
End Sub
'================
Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 13 Then
An
ElseIf KeyCode = 27 Then
Range(ComboBox1.LinkedCell) = ""
An
End If
End Sub
'============
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 7 Then
Hien Target
Else
An
End If
End Sub
'====================
Sub Hien(Rg As Range)
With Me.ComboBox1
.Visible = True
.Top = Rg.Top
.Left = Rg.Left
.LinkedCell = Rg.Address
.Activate
End With
End Sub
'=============
Sub An()
Me.ComboBox1.Visible = False
ActiveSheet.Range(ComboBox1.LinkedCell).Offset(1).Select
End Sub