VBA to Autocomplete text in the same column

[Ramadan]

It seems that Autocomplete text in excel works only in the same current page of excel sheet while when I go down to a new page, it doesn't work
I works on a daily list of tasts where I need to assign a team member in front of each task and as the team names are almost the same people so I need excel to autocomplete the member name once I add his first letter of name like (Emy, Androw, Marina, Mary, etc... and these names are always in the same column ("F")

(IF POSSIBLE"), and if there are more than a name start with the same letter like "Marina & Mary" to dispaly the avaible name list
I have been searching for a code that can perferm that but unfortunaltey can,'t reach it

is there any suggessions please for such code

 

[HighAndWilder]

It seems that Autocomplete text in excel works only in the same current page of excel sheet while when I go down to a new page, it doesn't work
I works on a daily list of tasts where I need to assign a team member in front of each task and as the team names are almost the same people so I need excel to autocomplete the member name once I add his first letter of name like (Emy, Androw, Marina, Mary, etc... and these names are always in the same column ("F")

(IF POSSIBLE"), and if there are more than a name start with the same letter like "Marina & Mary" to dispaly the avaible name list
I have been searching for a code that can perferm that but unfortunaltey can,'t reach it

is there any suggessions please for such code

Would a Data Validation List work?

I have used a Userform in the past that shows when the cell into which I want to write data becomes the activecell.
This userform lists the values to select from.

 

[Ramadan]

.

 

[Ramadan]

Would a Data Validation List work?

I have used a Userform in the past that shows when the cell into which I want to write data becomes the activecell.
This userform lists the values to select from.

Thanks for your suggestion but for me navigating between names in drop list will take much time than writting the name manually