Search Contextures Sites

Excel Data Validation - Select Multiple Items

	Select Items With Drop Down List Select Multiple Items From Drop Down List Excel VBA to Select Multiple Items Download the Sample Data Validation File Video Multiple Item Selection Examples Video: Multiple Item Selection Setup Download the zipped sample file: Select Multiple Items from Excel Data Validation List
	Select Items With Drop Down List To make data entry easier, you can add an Excel data validation drop down list to your worksheet. Then, click the arrow, and select an item to fill the cell. In the worksheet shown below, you can select any month from the drop down list, and it overwrites any previous entry in the cell. Select Multiple Items From Drop Down List Instead of limiting the drop down list to a single selection, you can use a bit of programming, combined with the data validation list, and allow multiple selections. With a few adjustments to the VBA code, you can display all the selected items across a row, or down a column, or keep them in a single cell. Fill Across a Row In the first example, each item selected in this drop down list fills the next empty cell at the right. With this option, you could fill player names across a list of innings, or employee names for days of the week. Fill Down a Column Another option is to fill the selected items down a column, instead of across the row. Add Values To the Same Cell With another variation in the VBA code, you can keep all the selected items in the same cell, separated by commas. Excel VBA to Select Multiple Items The sample workbook uses Excel VBA code, which is set up to run automatically, when you make a change on the worksheet. To see the code for the SameCell sheet, you can right-click the sheet tab, and click on View Code. In the sample code shown below, column 3 is the only one where the change will occur. In your workbook, you could change the 3 to a different number. Or, if you don’t want to limit the code to a specific column, you could delete the two rows that are marked with a red circle. Download the Sample Data Validation File To experiment with this technique, you can download the zipped sample file: Select Multiple Items from Excel Data Validation List Video Multiple Item Selection Examples To see these techniques, and a few other multiple selection examples, you can watch this short video. Video: Multiple Item Selection Setup To see the steps for setting up data validation with multiple selection, watch this short video tutorial

Excel Tutorials - Data Validation

Data Validation Basics Data Validation - Create Dependent Lists Data Validation - Dependent Dropdowns from a Sorted List Data Validation - Dependent Lists With INDEX Hide Previously Used Items in a Dropdown List Data Validation - Display Messages to the User Data Validation - Display Input Messages in a Text Box Data Validation - Use a List from Another Workbook Data Validation Criteria Examples Data Validation Custom Criteria Examples Data Validation Tips Data Validation Documentation Data Validation Combo Box Data Validation Combo Box - Named Ranges Data Validation Combo Box -- Click Data Validation - Add New Items

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright ©2012 All rights reserved.	Debra Dalgleish

Last updated: November 15, 2011