29048721--HainKurt-.xlsx

<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Accept: HainKurt (<a href="https:#a42243627" rel="ugc">https:#a42243627</a>)<br />
<br />
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.<br />
<br />
MacroShadow<br />
Experts-Exchange Cleanup Volunteer
</div>


No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: HainKurt (https:#a42243627 [https:#a42243627])

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
HiMartin,<br />
I had this question after viewing <a href="https://www.experts-exchange.com/questions/28079408/How-to-create-dropdown-with-autofill-autocomplete-in-Excel.html" rel="ugc">How to create dropdown with autofill/autocomplete in Excel</a>.<br />
<br />
Can i use the code you provided &nbsp;in the the &quot;this workbook&quot; or module in Vb? I have so many sheets and i though its better to do it one time &nbsp;rather that pasting this to all sheets in VBE.<br />
<br />
If it also not too much to ask, may I add in my question; if this code can be done that any string to be inputted in the combo box will provide suggestion options from the data validation drop down &nbsp;list (really like a google type behavior)?<br />
<br />
Thanks,<br />
Reggieneo
</div>
</div>


HiMartin,
I had this question after viewing How to create dropdown with autofill/autocomplete in Excel (https://www.experts-exchange.com/questions/28079408/How-to-create-dropdown-with-autofill-autocomplete-in-Excel.html).

Can i use the code you provided  in the the "this workbook" or module in Vb? I have so many sheets and i though its better to do it one time  rather that pasting this to all sheets in VBE.

If it also not too much to ask, may I add in my question; if this code can be done that any string to be inputted in the combo box will provide suggestion options from the data validation drop down  list (really like a google type behavior)?

Thanks,
Reggieneo

auto search option from drop-down as you type

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.

VB Script

Google is an American multinational technology company specializing in Internet-related services and products that include online advertising technologies, search, cloud computing, software, and hardware.

Google

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.