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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

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,072
Messages
5,545,822
Members
410,707
Latest member
SanTrapGamer
Top