one column validation checks

[missy22]

Dear all,

I am currently experiences an 'run time error' with the following code below:

Please Login or Register  to view this content.

The purpose of this code is checking values in column G on the criteria provided in the sample excel file with data.
validation.xls

I am trying to incorporate three criteria into my code and so far I have one due to run time error in the code, which I am not sure why.

Any help and guidance would be very much appreciated.

Thank you for your time and help.

[missy22]

Hello, Any guidance to what am I doing wrong in the above code would be very much appreciated.

Thank you