Results 1 to 4 of 4

Thread: searchable drop-dwn in excel and vllookup to display data

  1. #1
    Neophyte NetSy's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    2016

    searchable drop-dwn in excel and vllookup to display data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi,

    how can i retrieved data selected from searchable combo box values and vlookup with data in sheet3. e.g if 'ban ki moon' is selected then roles should be "Politician" displayed in the roles cell.
    Attached Files Attached Files

  2. #2
    Neophyte Knoet's Avatar
    Join Date
    May 2019
    Posts
    4
    Articles
    0
    Excel Version
    2016
    See attached.
    Set properties like the pictures.

    Click image for larger version. 

Name:	combo.jpg 
Views:	11 
Size:	95.7 KB 
ID:	9153
    Code goes in sheet Searchable_dropdown_list1 (2) module.
    Code:
    Private Sub ComboBox1_Click()
        [H7].Value = ComboBox1.Column(1)
    End Sub
    Attached Files Attached Files

  3. #3
    Neophyte NetSy's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    2016
    hi, thxs a lot.
    I have more query & help pls..
    In sheet3 of the excel, I have added some more columns i.e
    (C = Category and D = Country) and I want to return values in column D when the specific record is selected in the drop-down.

    how can I amend the code pls?

  4. #4
    Neophyte Knoet's Avatar
    Join Date
    May 2019
    Posts
    4
    Articles
    0
    Excel Version
    2016
    Hi,
    Like this?
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •