On the ribbon, click the data tab, and click data validation.

How to create drop down list in excel using macro. Web here is how you can directly enter it in the data validation source field: Web sub macro1 () ' ' macro1 macro ' ' keyboard shortcut: Web select a cell in which you want the dropdown to appear (d3 in our case).

Then right click the sheet tab contains the drop down you want to use, and then choose view code from the. Select a cell where you want to create the drop down list (cell c2 in this example). Select the cells that you want to contain the lists.

On the data tab, in the data tools group, click data validation. We will use the validation.add. In the data validation dialog.

Web create a drop down list. Web firstly, create a drop down list as you need, see screenshot: In the dialog, set allow to.