Your validation program

Tags
Challenge
No

Write a program about whatever you like, that has:

  • Input from the worksheet.
  • At least one string, and one numeric input.
  • Output to the worksheet.
  • Validation of all input. Numeric and range check (numeric input), and normalization (string input).
  • All error messages shown on the worksheet.
  • Old output and error messages cleared at start.
  • Output depends on input values, tested with one or more Ifs.

See the other exercises on this page if you need inspiration. Silly is OK.

Upload your workbook. The usual coding standards apply.

Where referenced