| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Predictive Text based on cell range?
Is there any way to set the predictive text for a column/cell to refer
to a range? Example: My list is in Column E. (E1:E50) Mary Bob James Larry Kevin Whenever someone begins typing a name in A1, it searches and finishes the name. Kev I know that Excel predicts sometimes, but not consistent. I want to predict based on a set criteria. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Predictive Text based on cell range?
Why not simply use Data Validation for cell A1, and have it obtain its list
from range $E$1:$E$50? See the Validation command in the Data menu (Excel 2000). -- Regards, Bill Renaud |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
| force text in a cell based on value of cell in a range | Excel Programming | |||
Linear Mode
