ComboBox With Autocomplete in whole Column instead of Single Cell

[bobby786]

Dear All Experts ,
I have created a drop down list with ActiveX comboBox to make it Autocomplete when users type data. I got the Help to create this combo box by searching for that topic. Right now i have Orders sheet and Cell B2 which is working fine. But i want this feature in my whole B2 column , i cannot find a way out for it , If anyone can help me for it would be great.

my sample sheet is uploaded on below link

Sample.Orders.And.Vendors.xlsm

drive.google.com

Regards
Bobby

 

[davesexcel]

If target.Validation.Type = xlValidateList Then

Your other cells need to have datavalidation

 

[bobby786]

If target.Validation.Type = xlValidateList Then

Your other cells need to have datavalidation

Thank you for taking time to reply me , can you please let me know where to add that vda code , i am new to vba.

 

[davesexcel]

I was explaining why it only works for the one cell, the first cell has datavalidation, but your cells below do not.

 

[bobby786]

Ah , ok ,got it , Thank you very much.

Regards