Ok here is my problem...

Basically some cell entry variations have multiple validation reasons.

For example Cells PSC (salary scale) and PPT (salary point)

If both PSC and PPT are blank then they pass

If both PSC and PPT have a value they pass

If PSC has a value and PPT is blank msgbox (you must select a scale point)

If PSC is blank and PPT has a value msgbox (you must select a salary scale first)

This is my code for this particular item in the validation, the problem is, is that it will work if they are both blank and if they both have a value and if PPT has a value and PSC is blank

BUT*** it doesn't work is PSC has a value and PPT is blank.

How can I over come this, I have about 4 instances where this happens


3:          If Range("PPT") <> "" Then
                If Range("PSC") = "" Then
                    Range("PPT") = ""
                    MsgBox ("You must select a salary scale first")
            If Range("PPT") = "" Then
                If Range("PSC") <> "" Then
                    MsgBox ("You must select a scale point")
                Else: GoTo 4