Bonjour,
Si ton classeur est en mode L1C1 ...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo 0
If Not Application.Intersect(Target, Range(Cells(2, 18), Cells(9000, 18))) Is Nothing Then
'Application.EnableEvents = False
Dim Tout_Manager As Range, Ligne_Liste As Integer, Liste As Worksheet
Ligne_Liste = Sheets("Liste_BELLINI").Cells(1000, 24).End(xlUp).Row
With Sheets("Liste_BELLINI")
Set Tout_Manager = .Range(.Cells(2, 24), .Cells(Ligne_Liste, 24))
End With
With ActiveCell.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=Liste_BELLINI!" & Tout_Manager.Address
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
Application.EnableEvents = True
End If
End Sub
ric