Sub Liste()
Dim mem$, f$, x$, c As Range, message$
With [A1] 'à adapter
On Error Resume Next
If .Validation.Type <> 3 Then Exit Sub 'il faut une liste
On Error GoTo 0
mem = .Formula
.Formula = .Validation.Formula1 'copie la formule de validation
x = .Formula
.Formula = mem
End With
If IsError(Evaluate(x)) Then
MsgBox x
Else
For Each c In Evaluate(x)
message = message & vbLf & c
Next
MsgBox Mid(message, 2)
End If
End Sub