How to embed a data validation control in Excel. ... The code is simple on purpose, but when you apply the technique to your own work, the code will most likely be more complex.