Macro to search all sheets for text or numbers

[mulcahcf]

Basically, in my head I am envisioning a search button next to a text box (similiar to what you would see on any search engine). I would like the user to be able to type whatever they are looking for in the text box, then by clicking the search button the macro would search all sheets to find any form of a match. Since I'm assuming there will be multiple matches, I need a function that will allow the user to see the results and choose which one theyre truly looking for. I have no idea how I would go about this. Also, I need the user to be able to search for text, numbers, or both. I have very basic knowledge of VBA and am having trouble making it happen. Any help or suggestions would be awesome!

I tried to contact google for some code, but I never got a response.

Thanks,
Chris

[Whizbang]

All of this functionality is already in place in the existing Find function.

Simply click the "Options" button in the Find dialog box. You will see an option stating "Within" and then a drop-down. By default "Sheet" is selected, but you can choose "Workbook". Then select "Find All" and it will list all results as rows in the dialog box.