Auto showing a text

  • Thread starter Thread starter michelle_ho
  • Start date Start date
M

michelle_ho

This function is alway seen on Excel, but don't know how to write i
code.

Suppose I have several words:
Apple
Ada
Amy
Banana

When a user type "Ap" in a cell, it will automatically show the wor
"Apple". i.e., showing the nearest word which has the same inita
letters as the user entered.

How can i do so?

Thx a lot
 
You could try Data Va;idation
If your list of words is range named "MyList" theset the data validation on
your celll/s to Data Validation. allow LIST and set the source to =MyList
 
Back
Top