Autocomplete Possible?

  • Thread starter Thread starter R Doornbosch
  • Start date Start date
R

R Doornbosch

If I have a list of names on Sheet2 is it possible to write code or link
column A in Sheet1 so that when someone starts typing in the last name it is
autocompleted? and then do the same for their first name so that only the
First names that match the last names are allowed to be selected. OR should
I just change everything over to MS Access?
 
Hi

A workshees cell can't do that, it has too many other concerns. A combobox can, wether
it's located on a worksheet or on a userform.

But if you "just as well might use Access" I suggest you do just that. Excel is primarily
a math and analysis tool, not a data i/o application.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autocomplete 1
Is there a limit to how far autocomplete will match user input? 1
Possible to refer to a sheet's object name ? 10
UDF does not show up in Autocomplete 4
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
VBAscript for data matching excels 0
Compating all rows in two sheets 2
autocomplete in calendar 1

Back
Top