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.
|