Auto fill

Hi all,

is there a way when i start typing into a cell it will suggest matches as i start typing if there is a big list.

i.e.

this is the start of something i am typing then i have a drop option to allow me to click rather than type the whole entry?

"To"

Tomatoe
Tommorow
Today
Total


Thanks D

you can, search autocomplete data validation.... I used in a workbook years ago but cannot find a copy

Attached is a method using a userform

Trying to do it without a user form, thanks anyway

https://trumpexcel.com/excel-drop-do...h-suggestions/