- That they are all 4 digits exactly?
- That they are 4 consecutive ascending digits?
- That every digit of 1234 is 1 more than every digit of the previous number (0123) etc?
- Something else?
Sorry I think my explanation was not clear:
This is a new form to put it; I will always have the code look at cell A1.
Then in that cell we are looking for any of those numbers as listed above. Then throw the msgbox as before. I hope this makes it clearer
So, just like data validation?
Except that "those numbers as listed above" finish with "Etc".
Where does the "Etc" end? What is the full list of valid numbers? Is it just the 7 numbers I listed in my second screen shot in post 14?
-The full list of the numbers is supposed to be unlimited ; any number with the consecutive number form of "ABCD" is part of the list.
- "Etc" is not part of the list I used it there to show the sequence
So in cell A1, if the number has the form ABCD like 0123, 1234, ... Then we call the msgbox
So there has to be 4 digits and they have to be consecutive.
I'm clearly not understanding. Could you give me one more example of a 4-digit number with consecutive digits other than those 7 examples in the bottom screen shot of post 14?
Can you also confirm that the cell being looked at is formatted as Text, since 0123 would not normally show that leading zero?