Q-27975402.xlsm

<div>
<div class="content wysiwyg-content">
Hello Experts!<br />
<br />
&nbsp; &nbsp; &nbsp; I have yet to come across anything in my research that assist me in finding multiple keywords in Excel when performing a search through a spreadsheet that can consist of over 100,000 rows with 18 columns.<br />
<br />
&nbsp; &nbsp; &nbsp;A Macro would do this, but a macro can be time consuming when setting up each search. &nbsp; I need something like a VBScript or .HTA that has a GUI that will allow me to browse out to the .xls or .xlsx file Open it, add my list of keywords that I want to search on. &nbsp;Once my keywords have been entered, I could just click &quot;Start&quot; it would scrub through the entire worksheet looking for these keywords and highlight them as it finds them. &nbsp;It might even provide a location in the spreadsheet for each find, just as the native search function does in Excel. I could then open that workbook and see the highlighted keywords. &nbsp;<br />
<br />
&nbsp; &nbsp; An help is greatly appreciated!
</div>
</div>


Hello Experts!

      I have yet to come across anything in my research that assist me in finding multiple keywords in Excel when performing a search through a spreadsheet that can consist of over 100,000 rows with 18 columns.

     A Macro would do this, but a macro can be time consuming when setting up each search.   I need something like a VBScript or .HTA that has a GUI that will allow me to browse out to the .xls or .xlsx file Open it, add my list of keywords that I want to search on.  Once my keywords have been entered, I could just click "Start" it would scrub through the entire worksheet looking for these keywords and highlight them as it finds them.  It might even provide a location in the spreadsheet for each find, just as the native search function does in Excel. I could then open that workbook and see the highlighted keywords.  

    An help is greatly appreciated!

VBScript:  Search through an Excel Workbook for Multiple Keywords

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.