Web firstly, create a drop down list as you need, see screenshot:
How to add drop down list in excel macro. Web this article demonstrates how to run a vba macro using a drop down list. In the data validation dialog. To remove an item, press delete.
Web it’s easy and we’ll show you how. The drop down list contains two macro names macro1 and macro 2, however, you can. Web follow the simple steps below to open up the vba macro editor.
This will open the visual basic window. Web on the ribbon, click data > data validation. It shows the 2 ways you can do that in excel using formulas and vba.
Then right click the sheet tab contains the drop down you want to use, and then choose view code from the. Web to add an item, go to the end of the list and type the new item. Simply click the arrow and select an option.
On the data tab, in the data tools group, click data validation. Web select a cell in which you want the dropdown to appear (d3 in our case). Go to developer tab >> visual basic.
If the item you want to delete is somewhere in the middle of your list, right.