If/Then when dealing with data validation

[narrowgate88]

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

If CampusName = "CLICK TO PICK CAMPUS" Then MsgBox "Please click ok to select Campus Name.", vbOKOnly + vbExclamation, "Required Information is Missing"

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

If Range("CampusName").Value = "CLICK TO PICK CAMPUS" Then _
MsgBox "Please click ok to select Campus Name.", vbOKOnly + vbExclamation, "Required Information is Missing"