I'm trying to construct an IF-Then statement.
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.![]()
If CampusName = "CLICK TO PICK CAMPUS" Then MsgBox "Please click ok to select Campus Name.", vbOKOnly + vbExclamation, "Required Information is Missing"
Bookmarks