VBA Worksheet Change from Table Cell

[bs0d]

I'm trying to identify if a certain cell value changed in a table. Following examples found within the forum here, I'm only able to identify if the change occurs in a specific column. How can I adjust to a specific cell within the table?

I want to execute additional code if it's the first cell in the second column of my table.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Count <> 1 Then Exit Sub

    If Not Intersect(Target, Range("MyTable[MyColumnName]")) Is Nothing Then

        On Error GoTo CleanUp
       Application.EnableEvents = False
  
 Msgbox "Success"
  
    Else
    
        On Error GoTo CleanUp
        Application.EnableEvents = False

    End If

CleanUp:
    Application.EnableEvents = True
    
End Sub

 

[shg]

Target.Address gives the address of the changed cell(s).

 

[Marcelo Branco]

Maybe...

If Not Intersect(Target, Range("MyTable[MyColumnName]").Cells(1)) Is Nothing Then

M.

 

[bs0d]

Maybe...

If Not Intersect(Target, Range("MyTable[MyColumnName]").Cells(1)) Is Nothing Then

M.

That does the trick. Thanks for the help!

 

[Marcelo Branco]

That does the trick. Thanks for the help!

You are welcome. Thanks for the feedback.

M.