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

J

JRSCEI

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
 
J

Jeff

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.
 

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

Searching a row one cell after another 5
Pasting values from a textbox into a single cell on a spreadsheet 3
Add Search Box to Spreadsheet 1
Is it possible? 5
Please help! Database lookup from excel 1
finding next number in a sequence 3
Eliminate blank row at top of Text Box entries 3
Search and list in a new worksheet 3 cells from up to 1000spreadsheets 3

Top