ExcelBanter - drop down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - drop down list (https://www.excelbanter.com/excel-programming/446537-drop-down-list.html)

drop down list

Is there a way that you can get all the data in the drop down list and get rid of drop down list itself? The soure cata was from another file I could not find anymore. Thanks,

All times are GMT +1. The time now is 06:38 AM.