Web create a yes/no drop down list via vba ask question asked 7 months ago modified 7 months ago viewed 102 times 0 i wrote a script to create a yes/no drop.
How to create drop down list in excel yes no. And then, insert the vba. Web it can be in the same worksheet or another one. First, you make a regular data validation list in one or more cells.
In the dialog, set allow to. Add to an existing table open. Then, customize the list using the data validation options.
On the first sheet, select cell b1. On the ribbon, click the data tab, and click data validation. Select the cells that you want to contain the lists.