No sorry. I guess I should rephrase. That wasn't what I meant. Under the Formulas tab in the defined names area, I can create a drop-down list. When I finished creating my list that I wanted, I went to type in where the cell is located and it only allows me to click the drop down arrow and search for the name that I want. I was hoping that instead of always clicking on the drop down arrow, I could just start typing in the name and it would predict or forecast the name that I want. I have a very long list of names, in the hundreds and it is a pain to have to always select the drop down arrow and scroll down to locate it. Not very efficient.

You can just type the whole name in, right?

I reckon you could write a macro that lists all the names in a listbox or combobox, and code it to do autocomplete on that, but it seems like a lot of effort for not much gain.

I expect it doesn't auto-complete because you can also use the Names box to add a named range to the worksheet or workbook.