Скачать с ютуб Add New Items to Excel Drop Down List в хорошем качестве

Add New Items to Excel Drop Down List

http://www.contextures.com/excel-data... Visit this page for written instructions, and to download the sample file. With a data validation drop down list, you can make it easy to enter data, and show a warning if an invalid item is entered. That's useful in most cases, but occasionally you might want to allow users to add their own items to the drop down list. With a bit of programming, you can ask users to verify new items, then add them to the list, sorted alphabetically. This video shows you how this technique works, and explains breifly how the Excel VBA code works. You can download the sample file from the link shown above, and add it to your own files. Just change the sheet names, if necessary, to match your workbook.