ComboBox With Autocomplete in whole Column instead of Single Cell

bobby786

Board Regular
Joined
Apr 24, 2014
Messages
56
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

Regards
Bobby
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

davesexcel

Well-known Member
Joined
Feb 26, 2006
Messages
1,026
If target.Validation.Type = xlValidateList Then

Your other cells need to have datavalidation
 

bobby786

Board Regular
Joined
Apr 24, 2014
Messages
56
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

Well-known Member
Joined
Feb 26, 2006
Messages
1,026
I was explaining why it only works for the one cell, the first cell has datavalidation, but your cells below do not.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,278
Messages
5,546,939
Members
410,764
Latest member
Dedeke
Top