Paste full cell from a list using dropdown
Closed
Hello,
This is my first question on this forum.
I made a dropdown list in Excel to choose some data from a huge list in which i dont have just simple values but comments also.
Should it be possible to have full record from the cells in that list by using dropdown list in any other worksheet?
Thank you very much
This is my first question on this forum.
I made a dropdown list in Excel to choose some data from a huge list in which i dont have just simple values but comments also.
Should it be possible to have full record from the cells in that list by using dropdown list in any other worksheet?
Thank you very much
Related:
- Paste full cell from a list using dropdown
- Counter strike 1.6 cheats list - Guide
- Amd crossfire gpu list - Guide
- Safari download list - Guide
- How to change your best friends list on snapchat to 3 - Guide
- All contact number list with name - 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
