Did you know?

EasyXLS™ library allows you to create drop down lists in Excel file. A drop down list is a data validation that permits entering only values from the list in the cell
Example of how to add data validation and drop down lists to an XlsxWriter file. Data validation is a way of limiting user input to certain ranges or to allow a selection from a drop down list
Since an ActiveX Listbox is not presented in a "Dropdown" format, it is mentioned for completeness only.2. To make an ActiveX ComboBox function as a dropdown list, set the MatchRequired property = True and the Style property = frmStyleDropdownList3