Select Case code not returning correct statement

This is my code which I use in conjunction with a drop-down list. The "ni" range is the output range for the drop-down box. The "n" in the case statements is the value I want associated with the "ni", and the "nval" is the output where the value for "n" goes. When I try to run this code, The value for "n" that is returned is 0. I am not very good at vba and therefore cannot find where my problem is. This is the code.

Please Login or Register  to view this content.

I have another Select Case sub in my program that works perfectly, and has the same format as this one.

Then the value of Range("ni") is none of the values you have listed.

But when I step through the sub, it will stop at the appropriate case, go to end select, but when I check the range "nval" it has 0 in it. I have also changed "ni" to other arbritary cells, and directy input values into the cells, with the same results.

Does it execute one of the "n=x" statements?