Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto complete cell from a list of choices
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you add data into the auto-complete list? | Excel Discussion (Misc queries) | |||
auto-complete from a drop down list and from a different workbook | Excel Worksheet Functions | |||
auto complete in list | Excel Discussion (Misc queries) | |||
Auto complete in a validation list | Excel Discussion (Misc queries) | |||
Auto-complete an entry in drop-down list | New Users to Excel |