Autocomplete Vendor Name in Excel from an Access Database

[ebrandt]

Is it possible to "Autocomplete" a Vendors name in an excel cell from an Access Database of vendors and then perform a vlookup from the database for contact name, address, phone, email, etc.... in adjacent cells?

For example if I begin typing "Acc" then I automatically get a list of vendors from my vendor database in Access beginning with Acc to choose from, such as Accent Cabinet, Access Grage Doors, etc...

 

[Jerry Sullivan]

I'm not aware of a way to do that with data entry into Worksheet Cells.

You might find consider using a ComboBox. The Contextures site has an example of one approach.

http://contextures.com/xlDataVal10.html