I tried changing my variable  val to val1 but type mismatch error  still
encountered.
In the code  below, I think the problem lies in the line :

ElseIf val  >= 700 And val <= 800 Then

Because I entered  a letter, reads that letter i entered but it's
comparing to a number. How should I fix this so that if I enter a
letter, it will not compare to the number  of the "if " conditions? I
thought the last "else" command in my code will take care of any other
other input other than the defined conditions in the "if" lines.