Do Excel tables have event procedures

[Roland Hoelscher]

One of my Excel applications uses various Excel tables. Do Excel tables have associated event procedures e.g. events for change, delete, add, etc.?
It seems like that would be a nice feature, but have not been able to find relevant information.

Thank you in advance.
Roland

 

[MagnarH]

There are plenty, but you would have to make it an macroenabled workbook. And some code for each sheet.

Just google something like: vba event overview to get an idea.

Good luck.

 

[RoryA]

Tables themselves (Listobjects in VBA) do not have any events, but you can monitor Worksheet events like Change and check if the changed cells are inside your table(s).