I suggest to use an activex combobox (in excel 2007, under developer.
How to add drop down list in excel using vba. Then click on the data validationbutton on the data ribbon: Our advanced excel training covers: Web how to set dropdown selection from code in excel (vba) ask question asked 9 years, 8 months ago modified 5 years, 6 months ago viewed 21k times 3 i am trying to make a.
Web step 2:select the cell you would like to add the drop down listto. Having placed the cursor on the «source:» field, go to the sheet and select the required cells. With the ability to prevent duplicates and remove incorrect items, this feature can streamline.
Web in order to create one of these dropdownlists(comboboxes) all you need to do is click on the comboboxon the tool box and click somewhere on the userformwhere you.