Sub ListeValidations()
Dim Cell As Range, Vali As Validation
On Error Resume Next
M$ = ""
For Each Cell In ActiveSheet.Cells.SpecialCells(xlCellTypeAllValidation)
Set Vali = Cell.Validation
M$ = M$ & Cell.Address & ": Type=" & Vali.Type & ", Formula1=""" & Vali.Formula1 & """" & vbLf
Next
MsgBox M$
End Sub