If/Then when dealing with data validation

[narrowgate88]

I'm trying to construct an IF-Then statement.

Please Login or Register  to view this content.

This code isn't working correctly and I wonder if it is because "CLICK TO PICK CAMPUS" is a value in a data validation drop down.

[Bob Phillips]

Is there a trailing space in the DV list?

Where does CampusName get set?

[narrowgate88]

There is not a trailing space in the DV list.

The data validation is set to I3. I renamed that cell CampusName. Is that what you were asking?

[Bob Phillips]

Yes it is, so I guess the code should be

Please Login or Register  to view this content.