Auto complete when typing in drop down in Excel where list is filled using VBA
<p>I am using the below code to insert data into a drop down list from another sheet. This is achieved when the user selects a certain choice from another drop down list.</p>

<pre><code>lstRow = Sheets("Data Sheet").Range("D" &amp; Rows.Count).End(xlUp).Row
Sheets("Data Insert").Range("C3").Select
With Selection.Validation
    .Delete
    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
    xlBetween, Formula1:="='Associated British Ports'!$G$7:$G" &amp; lstRow
    .IgnoreBlank = False
    .InCellDropdown = True
    .InputTitle = ""
    .ErrorTitle = "Invalid Selection"
    .InputMessage = ""
    .ErrorMessage = _
    "Please select a user from the list or select New User as the configuration type."
    .ShowInput = True
    .ShowError = True
End With
</code></pre>

<p>I want to add in the function that when the user types in a few letters it searches through the list and eliminates anything that doesn't contain that. 
I.E. say I have the below in the dropdown:
A Thomas
c Smith
f Graham
t Evans
s davids
B matthews</p>

<p>And the user types in "th"
The remaining values should be</p>

<p>A Thomas
c Smith
B matthews</p>

<p>Even a simplified version where the user must type in the name in the form of A Th.... To return A Thomas would be okay if the above is not doable.</p>

<p>I have seen this <a href="http://www.ozgrid.com/Excel/autocomplete-validation.htm" rel="nofollow noreferrer">http://www.ozgrid.com/Excel/autocomplete-validation.htm</a> and this <a href="https://stackoverflow.com/questions/19818075/excel-data-validation-with-suggestions-autocomplete">Excel data validation with suggestions/autocomplete</a></p>

<p>but i dont think I'm not sure how to integrate this with the above code, or it is even possible!</p>

<p>Could anyone help me out please?</p>

<p>TIA :)</p>