The dropdown list (I assume Data Validation) has to be adjacent to the
entries you want for the autotext. For example, if you have some
entries in A1:A10, the autotext would work for A11 and below. If there
are blanks in the column, the auto text won't pick it up.

--JP


On Oct 5, 11:10*am, TONY wrote:
How can I get auto text to work on a drop down list?

Instead of having to scroll down I want to enter the first letter and it
will take to me the section I wish to use