Add an If check before the main code runs advice

[ipbr21054]

I have a code which transfers values from the open workbook to another workbook & all works fine.
I now need to add an if statement Before the main code runs.

Customers name is always in column A
The value to check if present or not is always in column I
The value to check for is KDX 2

So it should work like this.

A customer is selected in column A
The code must look in column I on this customers row & if KDX 2 is present then allow the rest of the code which i have currently in use.
If there is any other value in column I then show MsgBox & stop the code from running.

I think i can do it it the customer was selected in the same cell in column A every time BUT unsure when it could be anywhere

 

[ipbr21054]

As a test i did this but always shows NO

    If ActiveCell.Offset(0, 9).Value = "KDX 2" Then
    MsgBox "YES"
    Else
    MsgBox "NO"
    End If

 

[ipbr21054]

Ive now sorted the above issue out by using the following codewhich works fine.
Currently it will run even if i select another cell then iof offsets etc.
Im looking to make sure column A is first selected then continue

Private Sub Kdx2_Click()
   
    If ActiveCell.Offset(0, 8).Value = "KDX 2" Then
    Call KDX2TRANSFER
    Else
    MsgBox "KDX 2 WAS NOT USED ON THIS VEHICLE", vbCritical, "KDX 2 WAS NOT USED"
    End If
   
End Sub