Excel VBA :Searching A Value Across An Entire Workbook With Userform

TextBox on the userform was used for searching in this study.

Found results are listed on a listbox. The value can be searched into whole a workbook or into worksheet that you selected from drop-down list. When the items on the listbox clicked,can be went to item’s address.

All found results are listed as hyperlinks in the generated “Report Sheet”.

📥 Download Example Workbook

• Excel Tutorial