My VBA Video Lectures

 https://www.youtube.com/user/545sytes

My Videos on VBA Can be assessed from this link

VBA for Everyone

Variable Drop Down Menu / Data Validation (DV) List

Objective

In a model you need multiple drop down menus, the choice in drop down menus is dependent upon each other. Like if ones chooses Asia (in 1st menu), then only Asian Countries be available as second choice (2^nd menu); for Europe only European countries be prompted.

Drop Down Menu in Cell / Data Validation List

Objective

You need a Drop Down menu linked with a cell, that will show choices to user to Select, instead of typing.

This is useful when there are limited number of options to choose from.

6 Ways: Unique List of items from Multiple entries

Objective

You have some data where a particular field has many items occurring repeatedly and you need a list of unique items only like from (A,B,A,C,D,E,F,F,E,C,B,A,D) you need (A,B,C,D,E)