Excel : Search Entire Workbook
With Vba ,it is possible to search an entire workbook, for a searched value.
We will use The Find Method for this process.In Excel Program, The Find & FindNext Method is a very powerful option in finding data and is useful.
When the macro runs , inputbox opens and asks the data we want to find. The found results are listed on the MsgBox with cell addresses. The process continues until user stops it.