Function test_validation(Entree) As Boolean
Dim valeur As Double, nb As Long, i As Long
Dim table As Variant
test_validation = True
If IsNumeric(Entree) Then
valeur = CDbl(Entree)
If valeur >= 999999 Then test_validation = False
If valeur < 0 Then test_validation = False
If InStr(Entree, ".") + InStr(Entree, ",") > 0 Then test_validation = False
Else
If InStr(Entree, " ") > 0 Then
table = Split(Entree, " ")
nb = UBound(table)
test_validation = True
For i = 0 To nb
test_validation = test_validation And test_validation(table(i))
Next i
Else
test_validation = False
End If
End If
End Function
Sub test()
Dim toto
toto = test_validation("123456")
toto = test_validation("12345,6")
toto = test_validation("a123456")
toto = test_validation("a123 456")
toto = test_validation("123 456")
toto = test_validation("123 45 67")
End Sub