A Formula For Auto Complete

[itsgrady]

I have to type names in a random order all of the time. It would be nice that I have a column with all names that could be used to help auto complete the name in a cell. Each of the seven columns never has the same name in it on a given week.

 

[Peter_SSs]

Could you not use the column with all the names as the source for a Data Validation list? Then you could simply choose the relevant name from the drop-down list.
If the list is large then you could consider this option.

 

[itsgrady]

Could you not use the column with all the names as the source for a Data Validation list? Then you could simply choose the relevant name from the drop-down list.
If the list is large then you could consider this option.

I have over 75 names - makes for a long list.

 

[Peter_SSs]

I have over 75 names - makes for a long list.

We didn't know that to start with, but that possibility is why I included a work-around that includes autocomplete.

If the list is large then you could consider this option.

The option linked does not work on a Mac though but it does provide further options if it must work on your Mac as well as Windows.

 

[Jim Gordon]

You could make each item into its own User Defined Function. For Example:

Function David()
David = "David"
End Function

 

[itsgrady]

You could make each item into its own User Defined Function. For Example:

Function David()
David = "David"
End Function

View attachment 77657

Can I make them all in one Module? Is there a fast way to do it?