Paste full cell from a list using dropdown

Vallach - Apr 1, 2010 at 04:58 AM
 leo - Jun 23, 2010 at 03:37 AM

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

1 reply

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))

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