Скачать или смотреть Add Validation List From Selection Excel VBA Macro

In this video we will add a validation list from a selected range in Excel using VBA macros. There are basically two approaches to do that, either referring to the list of unique entries in other range (obtained with advanced filter), or referring to a comma delimited list. We are using the second approach, and take advantage of the collection object to get unique entries. Find a similar example in the in the Excel Macro Class blog under the following link: https://excelmacroclass.blogspot.com/...

You can find many other macro examples and Excel VBA learning materials (including the Excel VBA Guide for Beginners) in the blog under the link: https://excelmacroclass.blogspot.com/

And yet, if you want more, you can find various Excel applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (https://excelmacrofun.blogspot.com/)
Excel Macro Business (https://excelmacrobusiness.blogspot.com/)
Excel Macro Sports (https://excelmacrosports.blogspot.com/)