Autocomplete doesn't function properly
in [Programming]
|
From: John on 5 May 2010 07:58 Autocomplete only seems to function if there are not a lot of rows between the active cell and the matching text (all rows above the active cell are non-blank). For example, if there are a dozen or so rows between the active cell and the matching text cell, autocomplete works fine. If there are, say 50 rows between the active cell and the matching text cell, you must type more characters for autocomplete to complete your text. If there are several hundred nonblank cells between the active cell and your matching text, autocomplete ceases to function. Any one know a workaround?
From: Dave Peterson on 5 May 2010 09:22 Maybe using Data|Validation or even a combobox from the Control Toolbox toolbar??? John wrote: > > Autocomplete only seems to function if there are not a lot of rows between > the active cell and the matching text (all rows above the active cell are > non-blank). For example, if there are a dozen or so rows between the active > cell and the matching text cell, autocomplete works fine. If there are, say > 50 rows between the active cell and the matching text cell, you must type > more characters for autocomplete to complete your text. If there are several > hundred nonblank cells between the active cell and your matching text, > autocomplete ceases to function. Any one know a workaround? -- Dave Peterson
From: Dave Peterson on 5 May 2010 09:23 ps. Data|Validation won't allow autocomplete, but you could pick from a list. Comboboxes from the control toolbox toolbar do allow autocomplete. John wrote: > > Autocomplete only seems to function if there are not a lot of rows between > the active cell and the matching text (all rows above the active cell are > non-blank). For example, if there are a dozen or so rows between the active > cell and the matching text cell, autocomplete works fine. If there are, say > 50 rows between the active cell and the matching text cell, you must type > more characters for autocomplete to complete your text. If there are several > hundred nonblank cells between the active cell and your matching text, > autocomplete ceases to function. Any one know a workaround? -- Dave Peterson
From: aflatoon on 5 May 2010 08:32 Autocomplete only kicks in when there is a unique match in the list to what you have typed. Are you sure it's not that behaviour that you are seeing? (the more entries you have, the more likely it is you have to type more characters to get a unique match). J o h n ; 7 1 6 7 2 1 W r o t e : > Autocomplete only seems to function if there are not a lot of rows between > the active cell and the matching text (all rows above the active cell are > non-blank). For example, if there are a dozen or so rows between the active > cell and the matching text cell, autocomplete works fine. If there are, say > 50 rows between the active cell and the matching text cell, you must type > more characters for autocomplete to complete your text. If there are several > hundred nonblank cells between the active cell and your matching text, > autocomplete ceases to function. Any one know a workaround? -- aflatoon Regards, A. ------------------------------------------------------------------------ aflatoon's Profile: http://www.thecodecage.com/forumz/member.php?u=1501 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=200690 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: "fixed objects will move" warning Next: Updating another workbook |