VBA Excel: Dynamic Data Validation List ( Nested Drop Down )

Dynamic Data Validation List ( Nested Drop Down ): The below code will be used to do 'Data Validation' through macro. I have used this particular code to populate the drop-down list in a cell based on selection in the previous cell.