There are 2 ways that don't use macros:
One is to just type those entries further up the column (Excel spots them
and helps you by auto completing).
Another more restrictive way is to highlight the column, choose Data,
Validation and Allow "List". Under Source, either highlight a range
containing your values in a s/sheet or just type them with a comma between.

"raphiel2063" wrote:

How do I create an auto complete macro which runs when I double click a cell.
The idea is that the user double clicks the cell then can start typing in
something and it will reduce the auto-fill.
So if I started typing in "ta" it would show table because from the list
below the only possible item is a table.

Table
Chair
Stool
Desk
etc.