Help needed with VBA code

[PGD15]

Hi,

I am trying to write some VBA code that says:
If cell L92 contains any value other than yes end script, however if L92 equals yes then i want to check if L95 is blank, if L95 is blank display a message box, otherwise end script.

Thanks for any help!

 

[Special-K99]

Try

Sub Celltest()
    If cells(92,12)="Yes" and cells(95,12)="" then
        MsgBox "SOMETHING"
    End If
End Sub

 

[PGD15]

I've tried that, doesn't work :'(

 

[RoryA]

The comparison would be case sensitive. To avoid that you can use:

Sub Celltest()
    If LCase$(Range("L92").Value2) = "yes" and Range("L95").Value2 = "" then
        MsgBox "SOMETHING"
    End If
End Sub

 

[PGD15]

Rory once again thank you! you know everything :')