Autocomplete Possible?
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? |
Autocomplete Possible?
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. -- HTH. Best wishes Harald Followup to newsgroup only please. "R Doornbosch" wrote in message ... 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? |
All times are GMT +1. The time now is 04:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com