| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto complete in list
if i have many entries in a drop down list, is there a way to start typing
and it goes through the entries to the value. eg in the list there is Daa.. Dab... Dac... Dafa. Dafb. Dafc. Dag... .. .. .. if I start typing Daf - it takes me only to the entries beginning Daf?? Many thanks :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto complete in list
What did you use to create the drop downlist?
If you used data|Validation or a dropdown from the Forms toolbar, then nope. If you used a combobox from the Control Toolbox Toolbar, then yep. If you go into design mode, show the combobox's properties, you can play with ".matchentry". sedonovan wrote: if i have many entries in a drop down list, is there a way to start typing and it goes through the entries to the value. eg in the list there is Daa.. Dab... Dac... Dafa. Dafb. Dafc. Dag... . . . if I start typing Daf - it takes me only to the entries beginning Daf?? Many thanks :) -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto complete in list
"Dave Peterson" wrote: What did you use to create the drop downlist? If you used data|Validation or a dropdown from the Forms toolbar, then nope. If you used a combobox from the Control Toolbox Toolbar, then yep. If you go into design mode, show the combobox's properties, you can play with ".matchentry". sedonovan wrote: if i have many entries in a drop down list, is there a way to start typing and it goes through the entries to the value. eg in the list there is Daa.. Dab... Dac... Dafa. Dafb. Dafc. Dag... . . . if I start typing Daf - it takes me only to the entries beginning Daf?? Many thanks :) -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto complete in list
at the moment - its through data validation.
in sheet 2 i have a list of names and number A | B Name | Number Tom | 123 Dick | 456 Harry | 789 in sheet 1 i've two columns A and B - again called name and number - when i select Tom from column A , 123 appears in column b through vlookup. but i need a facility to start typing the beginning of the name to match the entry - can anybody help??? many thanks, suzie "sedonovan" wrote: "Dave Peterson" wrote: What did you use to create the drop downlist? If you used data|Validation or a dropdown from the Forms toolbar, then nope. If you used a combobox from the Control Toolbox Toolbar, then yep. If you go into design mode, show the combobox's properties, you can play with ".matchentry". sedonovan wrote: if i have many entries in a drop down list, is there a way to start typing and it goes through the entries to the value. eg in the list there is Daa.. Dab... Dac... Dafa. Dafb. Dafc. Dag... . . . if I start typing Daf - it takes me only to the entries beginning Daf?? Many thanks :) -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto complete in list
What happened when you tried replacing the Data|Validation cell with a combobox
from the control toolbox? sedonovan wrote: at the moment - its through data validation. in sheet 2 i have a list of names and number A | B Name | Number Tom | 123 Dick | 456 Harry | 789 in sheet 1 i've two columns A and B - again called name and number - when i select Tom from column A , 123 appears in column b through vlookup. but i need a facility to start typing the beginning of the name to match the entry - can anybody help??? many thanks, suzie "sedonovan" wrote: "Dave Peterson" wrote: What did you use to create the drop downlist? If you used data|Validation or a dropdown from the Forms toolbar, then nope. If you used a combobox from the Control Toolbox Toolbar, then yep. If you go into design mode, show the combobox's properties, you can play with ".matchentry". sedonovan wrote: if i have many entries in a drop down list, is there a way to start typing and it goes through the entries to the value. eg in the list there is Daa.. Dab... Dac... Dafa. Dafb. Dafc. Dag... . . . if I start typing Daf - it takes me only to the entries beginning Daf?? Many thanks :) -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto complete in list
which cell? the whole column? it's 300+ cells downwards. i've drawn a box -
but its empty - i don't know which properties etc... thanks "Dave Peterson" wrote: What happened when you tried replacing the Data|Validation cell with a combobox from the control toolbox? sedonovan wrote: at the moment - its through data validation. in sheet 2 i have a list of names and number A | B Name | Number Tom | 123 Dick | 456 Harry | 789 in sheet 1 i've two columns A and B - again called name and number - when i select Tom from column A , 123 appears in column b through vlookup. but i need a facility to start typing the beginning of the name to match the entry - can anybody help??? many thanks, suzie "sedonovan" wrote: "Dave Peterson" wrote: What did you use to create the drop downlist? If you used data|Validation or a dropdown from the Forms toolbar, then nope. If you used a combobox from the Control Toolbox Toolbar, then yep. If you go into design mode, show the combobox's properties, you can play with ".matchentry". sedonovan wrote: if i have many entries in a drop down list, is there a way to start typing and it goes through the entries to the value. eg in the list there is Daa.. Dab... Dac... Dafa. Dafb. Dafc. Dag... . . . if I start typing Daf - it takes me only to the entries beginning Daf?? Many thanks :) -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
auto complete in list
The combobox from the control toolbox toolbar could be placed over each cell.
You can rightclick on it and choose properties to set the linkedcell and listfillrange and matchentry. Get one working before you try all 300+. There could be other options--toolbar or move the combobox based on selected cell. sedonovan wrote: which cell? the whole column? it's 300+ cells downwards. i've drawn a box - but its empty - i don't know which properties etc... thanks "Dave Peterson" wrote: What happened when you tried replacing the Data|Validation cell with a combobox from the control toolbox? sedonovan wrote: at the moment - its through data validation. in sheet 2 i have a list of names and number A | B Name | Number Tom | 123 Dick | 456 Harry | 789 in sheet 1 i've two columns A and B - again called name and number - when i select Tom from column A , 123 appears in column b through vlookup. but i need a facility to start typing the beginning of the name to match the entry - can anybody help??? many thanks, suzie "sedonovan" wrote: "Dave Peterson" wrote: What did you use to create the drop downlist? If you used data|Validation or a dropdown from the Forms toolbar, then nope. If you used a combobox from the Control Toolbox Toolbar, then yep. If you go into design mode, show the combobox's properties, you can play with ".matchentry". sedonovan wrote: if i have many entries in a drop down list, is there a way to start typing and it goes through the entries to the value. eg in the list there is Daa.. Dab... Dac... Dafa. Dafb. Dafc. Dag... . . . if I start typing Daf - it takes me only to the entries beginning Daf?? Many thanks :) -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals in a list | Excel Discussion (Misc queries) | |||
| re-produce/loate auto filter list | Excel Worksheet Functions | |||
| Auto complete | Excel Discussion (Misc queries) | |||
| Auto complete? | New Users to Excel | |||
| Auto Complete not completing | Excel Discussion (Misc queries) | |||
Linear Mode
