The other way to test the data inside a variable is by using a Select case Statements. In visual basic, the Select case statements are just like If statement but with a little difference. For me, the Select Case statement is better and more efficient.

The If statements is one of the conditional Logic statements, that allows the programmer to specify which condition evaluates to true or false. Without the conditional statement, a program could not meet the condition requirement and possibly returns a different result. Sample Syntax If condition Then [ statements ] [ Else [ else statements ] ] The if statement is a decision statement, used to check a condition and if the condition is true then the statements following Then are executed.