Saturday, July 30, 2016

Searching A Value Across An Entire Workbook With Userform

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

            As an alternative to Ctrl + F, userform can be used.Unlike from Ctrl + F in this template,the found results are saved  to the created "report page".

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.

No comments:

Post a Comment