Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
predict text based on cell range?
predict text based on range name?
Is there any way to set the predictive text for a column to refer to a particular range. Example: I have a list of codes hidden in column E range named "codelist". sam123 sue123 sal123 tom123 tim123 toe123 Whenever someone else comes and begins to type into A1, sam I need the cell to search the range and autofill / predict that they are going to type in "sam123" and finish the text for them. i know that excel does this sometimes on its own, but i am looking to ensure that this happens, and want to control it by giving it a definite reference to search and predict. thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
predict text based on cell range?
Try Data Validation - you can tell the validation criteria to look at
a list which would be your codelist. HTH Toy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Predictive Text based on cell range? | Excel Programming | |||
Cell Colour based on text in Range of cells | Excel Programming | |||
Cell Colour based on text in Range of cells | Excel Programming | |||
show different text in cell based on range of #s in other cell | Excel Programming | |||
force text in a cell based on value of cell in a range | Excel Programming |