Python code: code the data validation function
The Excel result illustrated.
Programmed data validation in cells D4, D5, and D6.
Give the programmed range a name.
See video
Excel: Build data validation in Excel
Karl Hoitsma, P.E. (khoitsma)
Nice use of PyXLL!