Try Debra's page for the "AutoComplete" featu
http://www.contextures.com/xlDataVal10.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"Cpviv" wrote:
Is there anyway that we can get the Detection to flag partial name matches
in a populate list of matching words?

I have an example here. At cell B6, if I enter the wordings "Flower
Database", the cell should populate a list of matching words (John Database,
Suzy Database, JH Datebase Ptd) from its column B, to alert me that there are
a list of matching words and give me a dialog notes on whether to continue
entering the wordings "Flower Database". This detection needs to work at each
cell in Column B.

For example:

Column B

Row 1 John Database
Row 2 Suzy Database
Row 3 JH Datebase Ptd
Row 4 Happy Shoes Ltd
Row 5 Happy Suzy Shoes Inc