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.


4 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. When pressing search button the following error shows : Compile error :Can't find project or library. Any suggestions?

    ReplyDelete
  3. Is there an incomplete component in your excel version (in VBE- Visual Basic Editor)?

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete