Sub Macro2()
With Selection.Validation
.Delete
.Add Type:=xlValidateWholeNumber, AlertStyle:=xlValidAlertStop, _
Operator:=xlBetween, Formula1:="0", Formula2:="10000000"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = "Alerte"
.InputMessage = ""
.ErrorMessage = "Uniquement des nombres!"
.ShowInput = True
.ShowError = True
End With
End Sub