Data Validation Combo Box - Indirect Function/Limit to one column

I have a worksheet that contains cascading drop down data validation lists using the Indirect function. I have the following code that creates a data validation combo box allowing the cells to autopopulate as the user types. However, I am having trouble in the cells where the data validation is using the indirect function. I have searched the forums and I am not sure this is possible using VBA. Ideally I would like to have that functionality, but if it is not possible I need help restriction the code to just one column (say column B) so that the other data validation cells can operate without the combo box feature.

Please Login or Register  to view this content.

Thank you so much for your help!

Where should I place your code suggestion in the code I already have?

The template file I created containing this code is not Mac compatible. I believe this is because the combo box contains Activex controls. Do you know if it is possible to modify the above code so that it does not use Activex, but still retains all of the functionality. Thank you so much for your help!