Is it possible to add a Search Box within a spreadsheet?
 

Is it possible to add a search box within a spreadsheet? For example if you
go the Menu you can click on the Find button and then enter a name; the
function then searches the database and finds matching entries. So I'm
wondering if you can add a similar "Search Box" within the spreadsheet which
will allow the user to simply type in an entry and have the macro find the
matching entries. Hope this is clear...Thanks

Is it possible to add a Search Box within a spreadsheet?
 

Try pressing F5. OR Ctrl + F, Or are you looking for a strictly programmatic
approch? In which case use the help file in vbe and search .Find Method.

"JRSCEI" wrote:

Is it possible to add a search box within a spreadsheet? For example if you
go the Menu you can click on the Find button and then enter a name; the
function then searches the database and finds matching entries. So I'm
wondering if you can add a similar "Search Box" within the spreadsheet which
will allow the user to simply type in an entry and have the macro find the
matching entries. Hope this is clear...Thanks