Search box that allows you to start typing and it will autofill the answer matching file names

[dpaton05]

I have a spreadsheet that I want to have something that allows me to start typing a name and it will auto fill as I type to match the name typed with the names on other spreadsheets that are kept in a folder called Young People that is within the folder of the spreadsheet. I am not sure how to do this, could someone give me some guidance please?

After enough letters are typed in and the correct name appears, I want to be able to press a button and have the relevant document open.

Thanks

 

[dpaton05]

Thanks Michael but I think I need to have a button to execute it, so I can work out how to do that.

 

[Michael M]

So just add a button...when the data has been entered into the combo box correctly the button macro will be something like

If ComboBox1.Value <> "" Then
'add your code
End If

 

[dpaton05]

Thanks Michael, I got it to work with this code and it is called from a command button.

Sub AddYP()
Dim NewYP As String

NewYP = Tracker.Cells(5, 4)
YP.Range("A" & Rows.Count).End(xlUp).Offset(1, 0) = NewYP
    
End Sub

 

[dpaton05]

Actually, I do want to get it working if I press enter.

I added code to the sheet module that has the combo box

Private Sub cboYP_Change()
Call AddYP
End Sub

I am pressing enter when the right item is selected but nothing is happening.

 

[Michael M]

Did you assign the macro to the comboBox ?
It must be an ActiveX comboBox

Private Sub ComboBox1_Change()
'your code
Endd Sub

 

[dpaton05]

That is what the code in post 24 does. It is also a activex combo box.

 

[Michael M]

Excel back on line....It works fine for me !!

 

[dpaton05]

Any ideas of things I could check on my end as pressing enter does nothing for me?

 

[Michael M]

You shouldn't have to press Enter !!
Once the comboBox is changed it runs automatically !

 

[Michael M]

It runs Ok for me....but the combobox calls AddYp Not Openfile !!
I alos note you don't have a ListFill range in the ListBox !!