VBA code that looks for certain values from 2 columns which triggers a message box

[danbates]

Hi,

Please can someone help me?

I would like a VBA code that if the letter 'J' is entered in column E and then the number '8' is entered in column F and message box appears.

Any help would be much appreciated.

Thanks

Dan

 

[JLGWhiz]

It seems like you want event code that will run as a user makes an input. If so then

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
    If Not Intersect(Range("E:E"), Target) Is Nothing Then
        If Target = "J" And Target.Offset(, 1) = 8 Then
            MsgBox "Hello"
        End If
    End If
End Sub

The "J" is case sensitive. Copy the code to the worksheet code module of the sheet where the entries will be made.

 

[danbates]

Hi JLGWhiz,

Thank you for your code, it's just what I was after.

Regards

Dan

 

[JLGWhiz]

Hi JLGWhiz,

Thank you for your code, it's just what I was after.

Regards

Dan

You're welcome,
regards, JLG