Autocomplete data validation list

I'm trying to allow autocomplete on a data validation list instead of having to scroll through all choices. I found you can create a combo box and add code, but I am getting an error when I click anywhere on the sheet. Compile Error: Ambiguous name detected: Worksheet_SelectionChange

I have a combo box added, which I names TempCombo as it instructed.

This is the code I used. Any ideas?

Please Login or Register  to view this content.

Or does anyone have a different way to achieve autocomplete in the data validation list?

Hm, It looks like I do. Do you know if I would have to have this code on the specific sheet that contains the data validation boxes, or could it be on a module?

The existing one is to allow me to click on a cell and trigger a copy of the info from the next couple of columns to the right, and paste down to the end of the current data on the sheet. Can you not Worksheet_SelectionChange on a sheet twice?

Here is the existing:

Please Login or Register  to view this content.

Thanks!

Hm. not seeming to work. So what you are suggesting is to use this code in total replacement of the original code I have, to combine both the original functionality and to add the data validation autocomplete?

Alright, here we go.

I attached our dumbed down sheets.

The Product Order Autocomplete Test workbook is basically an order form, someone calls in some orders, then we enter them on this log and send it out daily. When the order comes in, we go to the Master table at the top of the Orders sheet, and click in the dropdown boxes in D12:D14 depending on which store calls in, to choose the product to add to the order list for the day. The data validation lists are on the Product List sheet. The Location # column, E, updates via vlookup from the Master Product Sheet. After the correct Store and Product have been chosen, we click the corresponding blue cell for the product we need to add, and it pastes down below under the last table, which we start a new one each day.

The Add Row to Master Table button is just to add a new row to that Master sheet, as just copying and pasting or inserting rows does not keep the one click copy / paste function working.

The second sheet I attached, DEAL SHEET-DRAFT AutoComplete - Test, has the functioning data validation autocomplete. I highlighted some of the fields that you can double click and pop open the box and start typing.

The goal is just to get Product Order Autocomplete Test workbook to have a functioning autocomplete for the data validation cells.


Just let me know if this babbling makes any sense.


Thanks!

Hm, When I click on one of the data validation boxes, a drop down box appears, but the choices are blank, and when I start typing, nothing populates. For example, on the Orders sheet, I would like to be able to type in C12 and have Best Buy, Radio Shack or Target come up as I am typing, but it does not populate anything as I am typing. I have attached a screenshot of what happens when I click on it.

Thanks!