This video details the VBA code needed to apply data validation in an Excel table. There are two examples:

1. Apply data validation for dates, preventing entry of future dates
2. Data validation with a drop down list, whose drop down values exist in another table.
------------------------