Excel VBA Code for Data Validation Including Drop Down List

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.
------------------------

[@SimpleExcelVBA]

Nicely and smoothly explained, well done :)

[@jay55patel]

thank you. very helpful and you are a great teacher

[@daljeetsingh1231]

I have 2 Dropdown List with the same options (Included and Excluded) in different sheets. If I select " Included" in one dropdown list, it should also select "Included" on another dropdown list and vice versa. I am new in coding please help me out to crack this.

[@lokeshv9608]

Hi Chester. I have tried ur code and I have a doubt. What is the command to disable search option in drop down list. I want user to select only from the list and even if user try to manually enter something it should throw an error. Can you please help

[@moumitaghosh2967]

Thank you so much

[@wallnutburr]

your voice is calming you need to consider audio books

[@MegaJalton]

haahhahahahahahah

[@SahilTla]

I might sound rude and this comment may b unnecessary but dont we use audio software to tune our ‘original’ voice ?

[@mariannehernandez9055]

how to automatically update date when selected an item in dropdown in excel

[@stevennye5075]

very well explained!

[@md.shamsularefinmaruf3430]

please give us VBA Code in text format.........

[@khayourabdellah8727]

Perfect

[@MohAboAbdo]

Thanks ... Thanks

[@guillermovalle2397]

Hello Chester i need you email