Recent Addins ADO Application Arrays Charts Commandbars Count Dates Dialogs Events File access Files & Folders Functions Games Help Import & Export Lookup Off topic Other Outlook PivotTables Power Query Printing Problem solving Read me Searching Sorting Sound Strings Sum Time VBA programming VBE Workbooks Worksheets

Create data validation dropdowns based on different input source types, including table columns

 2022-08-03    Other    0    287

You can add a dropdown list to a cell in a worksheet by using the menu Data, Data Validation, Data Validation...
Here are a few examples showing how you can create data validation dropdowns based on different input source types, including table columns:

Data validation dropdown example 1

Data validation dropdown example 2

Data validation dropdown example 3

Data validation dropdown example 4

Data validation dropdown example 5

Note! You can also apply a defined range name to a table column and use this defined name as the source for your dropdown.
The INDIRECT function will no longer be necessary and the defined range name will change according to the table column size.

Click here to download an example workbook.
Updated: 2022-08-03 Requires: XL2007 File size: 82 kB