selection change event within a column of a table

[saurab8]

hi there,

I have been trying to figure this one out but no combiation seems to be working.

I have a table, called "ALLOCATION" in a sheet "RAW_DATA".
I want to trigger another marco when a empty cell of column "DATE" is selected of the able table.

I am using Excel 2016.

Macro that I wrote works, but it works for the whole column not just within the table.
I hope someone could help me out.

Kind regards
Saurabh

 

[John_w]

Welcome to MrExcel forums.

Try this code in the "RAW_DATA" sheet module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Dim table As ListObject
    
    Set table = ActiveSheet.ListObjects("ALLOCATION")
    
    If Not Intersect(Target, table.ListColumns("DATE").DataBodyRange) Is Nothing Then
        If IsEmpty(Target.Value) Then
            Clicked_Empty_Date_Cell table, Target
        End If
    End If
    
End Sub

And this in a standard module:

Public Sub Clicked_Empty_Date_Cell(table As ListObject, dateCell As Range)

    MsgBox "DATE cell " & dateCell.Address(0, 0) & " in table " & table.Name & " is empty"
    
End Sub

 

[saurab8]

Thank John_W for your help. The problem is fully solved. Really appreciate your help.

I wanted to add multiple rows in the table, but the sheet is protected. Above gave me an option to unprotect and protect the sheet, depending which cell is selected.

Cheers