Select the cells that you want to contain the lists.

How to add drop down list in excel app. On the data tab, in the data tools group, click data validation. In the data validation dialog. Select the data tools group from the data tab.

Then, customize the list using the data validation options. Web to add an item, go to the last row in the column, press enter or return, enter the new list item, and press enter or return again. In the data validation dialogue box, within the settings tab, select list.

Web application.enableevents = true end if end sub everything until now works great now with all that information i would like to add the when i choose a name. Select a cell, then select data > data validation. In source, type =my list name.

On the ribbon, click the data tab, and click data validation. Pick the allow menu from the. Web select this range, then click in the name box on the left hand side of the formula bar.

Web select a cell where you want to create the drop down list. Add code to remove and restore protection before the following. This article explains how to create a drop.

Let's say that the cell. Web select a cell in which you want the dropdown to appear (d3 in our case).