Bonjour,
c'est cette partie du code qui pose soucis, je n'ai pas l'adresse Target dans le Modules1:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call Module1.bulle(Target)
End Sub
Puis dans Module1:
Sub bulle(Target As Range)
Dim xrow As Integer
On Error GoTo ErrorHandler
Target.Validation.Delete
xrow = ActiveCell.Row
With Target.Validation
.Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator:=xlBetween
.IgnoreBlank = True
.InCellDropdown = True
.InputMessage = ActiveSheet.Cells(xrow, 1)
.ShowInput = True
.ShowError = True
End With
Exit Sub
ErrorHandler:
MsgBox Err.Number & vbLf & Err.Description
End Sub