This article discusses 7 different applications of the data validation drop down list in Excel with the VBA macro.