<div>
This solution works great! &nbsp;Thank you, Rgonzo1971.
</div>


This solution works great!  Thank you, Rgonzo1971.

<div>
<div class="content wysiwyg-content">
How can you combine a variable with Excel 2007 Search function? &nbsp;I do not want the user to run the search directly so I want to search built by what he/she enters into an input box. &nbsp; Below is a sample sheet and macro.<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column A<br />
Row1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TAR NBR<br />
Row2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1<br />
Row3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2<br />
Row4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />
Row 5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4<br />
Row 6 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5<br />
Row 7 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6<br />
Row 8 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7<br />
Row 9 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8<br />
Row 10 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; 9<br />
Row 11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 10<br />
Row 12 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 11<br />
<br />
&nbsp; Range(&quot;A1&quot;).Select<br />
&nbsp; &nbsp; Dim MyValue As Integer<br />
&nbsp; &nbsp; Dim TARNbr As Integer<br />
&nbsp; &nbsp; Prompt = &quot;Search for which TAR?&quot;<br />
&nbsp; &nbsp; Caption = &quot;Tell me...&quot;<br />
&nbsp; &nbsp; TARNbr = InputBox(Prompt, Caption, MyValue)<br />
&nbsp; &nbsp; Cells.Find(What:=&quot;TARNbr&quot;,<wbr /> After:=ActiveCell, LookIn:=xlValues, LookAt:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _<br />
&nbsp; &nbsp; &nbsp; &nbsp; True, SearchFormat:=False).Activ<wbr />ate
</div>
</div>


How can you combine a variable with Excel 2007 Search function?  I do not want the user to run the search directly so I want to search built by what he/she enters into an input box.   Below is a sample sheet and macro.

                       Column A
Row1		TAR NBR
Row2		1
Row3		2
Row4		3
Row 5		4
Row 6		5
Row 7		6
Row 8		7
Row 9		8
Row 10	        9
Row 11	      10
Row 12	      11

  Range("A1").Select
    Dim MyValue As Integer
    Dim TARNbr As Integer
    Prompt = "Search for which TAR?"
    Caption = "Tell me..."
    TARNbr = InputBox(Prompt, Caption, MyValue)
    Cells.Find(What:="TARNbr", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
        xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
        True, SearchFormat:=False).Activate

How to use an input box variable in an Excel search function

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.

Office Suites-Other

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.