Auto Complete or Predictive text

[Lostonxl]

I couldn't find exactly what I am looking for, if I missed it please steer me in the correct direction.

I have a list of customers >7000 I have those on sheet 2 named DATA in column E, each customer has a grade "A-D", In column D

My sheet 1 is a work order log that for each new work order opened you click a button and it creates a new blank row three, In column C is where I would type in this customer name. Im looking for it to predict the text and allow to autofill the box once enough characters have been entered to match the customer name. I need the name to match exactly as it is in sheet 2 to correspond with the grade of the customer, and to be uniform across the board. Ideally I would like a condition to run after that to color the cell ie: Grade A= green. I've tried several different codes in VBA to no avail.

It would be greatly appreciated if someone knew if this is possible. I'm all ears.

Let me know if further explanation is needed.

Thank you

 

[Akuini]

@Lostonxl
Welcome to the Forum.
I don't quite understand what you are trying to do.
Could you explain in more detail using an example?

and allow to autofill the box once enough characters have been entered to match the customer name

What box are you talking about? a textbox?

 

[Lostonxl]

What I'm looking to do is begin typing a customers name in this cell, and it to see what I am typing and referencing a list on sheet 2 I already have to begin predicting the customer name.

 

[Akuini]

If you're interested, here's an example of a searchable drop-down:

Macro to create searchable data validation+combobox

Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior: 1. The...

www.mrexcel.com

OR

use an add-in called "Search deList"

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

​

 

[Lostonxl]

If you're interested, here's an example of a searchable drop-down:

Macro to create searchable data validation+combobox

Excel doesn't provide a built-in way to search data validation list. So it could be hard to scroll through the list when the list is long. This searchable data validation+combobox is a way to deal with that problem. It has these behavior: 1. The...

www.mrexcel.com

OR

use an add-in called "Search deList"

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

​

Thank you so much, that will work. Thank you for such a quick response

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.