View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
raphiel2063 raphiel2063 is offline
external usenet poster
 
Posts: 47
Default Auto complete cell from a list of choices

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.