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

  • Thread starter Thread starter JRSCEI
  • Start date Start date
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
 
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

Macro search text boxes 5
Add Search Box to Spreadsheet 1
Check a 'Logsheet' for a match, before continuing a sub 3
Searching in an excel spreadsheet 0
Searching a row one cell after another 5
joining spreadsheets together for reports and queries? 1
VBA copy and paste data 2
Excel Is it possible to ask a question within a question? 0

Back
Top