![]() Then in the Source option, enter the range of the cells that you want to enter as the drop-down list ( $B$4:$B$23 in this example). You will get the Data validation dialogue box. Then go to Data>Data Validation>Data Validation under the Data Tools section. Select the cell where you want to enter the drop-down list.Step 2: Enabling that List to Accept Multiple Selections by VBA Code Step 1: Creating a Drop-Down List by Data Validation Our objective today is to create a drop-down list based on this data set that takes multiple selections. Here we’ve got a data set with the Names of some books in a bookshop called Martin Bookstore. Steps to Create Drop-Down List in Excel with Multiple Selections How to Create Drop Down List in Excel with Multiple Selections.xlsm
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |