View Single Post
 
Old 06-24-2010, 03:17 AM
virsojour virsojour is offline Windows XP Office 2007
Novice
 
Join Date: Jun 2010
Posts: 5
virsojour is on a distinguished road
Default search a list while typing in a cell

Is there anyway to make a cell in excel to act like a search box?

For example you have a name list in a separate sheet or column. While typing on a cell, a macro or formula would automatically search for a match on the name list... (and make popping suggestions of data to enter when a match is found in the list. Is there any such feature ?) Thank you.
Reply With Quote