One approach is:

Record a macro while you do a search  in the spreadsheet or workbook.
Edit that macro to use parameters where you want the user  to be able to
specify what is being searched for.
If you want a complex search you may need to create a userform  to allow the
user to select/specify parameters and search terms
Test your search macro/search form.
Put a button  on the main form  and make its click event call the macro/search
form.