Related:
- Paste full cell from a list using dropdown
- Counter strike 1.6 cheats list - Guide
- All contact number list with name - Guide
- How to change your best friends list on snapchat to 3 - Guide
- Amd crossfire compatibility list - Guide
- Whatsapp country code list - Guide
1 response
i also faced this problem and i got one solution for this. i don't know this will be helpful for you or not. if u know vba then add one combo box to your excel sheet and paste this code to visual basic editor
Private Sub ComboBox1_GotFocus()
Dim LastRow As Integer
ComboBox1.SelStart = 0
ComboBox1.SelLength = Len(ComboBox1.Text)
LastRow = Sheet1.Range("A65536").End(xlUp).Row
For i = 2 To LastRow
ComboBox1.AddItem (Sheet1.Cells(i, 1))
Next
End Sub
here i used Column A of sheet1. change it for your requirement. As you type in that combo the most matching result will be completed automaically.
For any queries ask me
Private Sub ComboBox1_GotFocus()
Dim LastRow As Integer
ComboBox1.SelStart = 0
ComboBox1.SelLength = Len(ComboBox1.Text)
LastRow = Sheet1.Range("A65536").End(xlUp).Row
For i = 2 To LastRow
ComboBox1.AddItem (Sheet1.Cells(i, 1))
Next
End Sub
here i used Column A of sheet1. change it for your requirement. As you type in that combo the most matching result will be completed automaically.
For any queries ask me
