Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ComboBox1
.Visible = False
If Intersect(ActiveCell, [A2:A6,A8:A12,A14:A18]) Is Nothing Then Exit Sub
.Left = ActiveCell.Left
.Top = ActiveCell.Top - 1
.Width = ActiveCell.Width + 14
.Height = ActiveCell.Height + 2
.LinkedCell = ActiveCell.Address(0, 0)
.ListFillRange = "Liste"
.ListRows = [Liste].Rows.Count
.Visible = True
End With
End Sub
Private Sub ComboBox1_MouseMove(ByVal Button%, ByVal Shift%, ByVal X!, ByVal Y!)
If X < ActiveCell.Width Then ComboBox1.Activate: ComboBox1.DropDown Else ActiveCell.Activate
End Sub