Data Validation ComboBox from Another Sheet

There is an Excel file that teaches how to perform the Data Validation ComboBox from Another Sheet operation.

Excel Format: Data Validation Combobox From Another Sheet

Contains VBA code that dynamically loads a data list from another sheet into a ComboBox control. An advanced input form is created by combining data validation and dropdown list features. Changes in the source list are automatically reflected in the ComboBox. Filtering to list only relevant records is also provided. Therefore it is a referenced technique in data entry forms requiring dynamic dropdown lists.

Hope it is useful.