Bonjour,
Les cellules fusionnées compliquent.
Dim Choix1()
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Range("A12:E12,A15:E15,A18:E18,A21:E21,A24:E24,A27:E27,A30:E30,A33:E33"), Target) Is Nothing And Target.Count = 5 Then
Set f = Sheets("données")
Set Rng = f.Range("c2:c" & f.[c65000].End(xlUp).Row)
Choix1 = Application.Transpose(Rng)
Me.ComboBox1.List = Choix1
Me.ComboBox1.Height = Target.Height + 3
Me.ComboBox1.Width = Target.Width
Me.ComboBox1.Top = Target.Top
Me.ComboBox1.Left = Target.Left
Me.ComboBox1 = Target(1).Value
Me.ComboBox1.Visible = True
Me.ComboBox1.Activate
Else
Me.ComboBox1.Visible = False
End If
End Sub
Private Sub ComboBox1_Change()
If Me.ComboBox1 <> "" Then
mots = Split(Trim(Me.ComboBox1), " ")
Tbl = Choix1
For I = LBound(mots) To UBound(mots)
Tbl = Filter(Tbl, mots(I), True, vbTextCompare)
Next I
Me.ComboBox1.List = Tbl
Me.ComboBox1.DropDown
Else
Me.ComboBox1.List = Choix1
End If
End Sub
Private Sub ComboBox1_click()
ActiveCell.Resize(, 5).Value = Me.ComboBox1
End Sub
J'ai désactivé le Change.
Boisgontier