Validating user input in excel vba

Figure D shows the results of entering alpha characters and too many (it could also be too few) characters.

We've closed the door a bit and only some values will make it through.

In this article, we'll look at simple examples of validating input values before committing them to the document.

Unfortunately, you can't verify that the entered ZIP code is the right ZIP code for a corresponding address.

It would be next to impossible to coordinate checks with the user's intentions.

Despite the business rule we applied, a user can still enter gibberish for one or both names.

In the next example, you can tighten things up a bit.

The ZIP code example we discussed earlier is great for illustrating an ajar control.

Leave a Reply