Consulting

Results 1 to 3 of 3

Thread: Searchable dropdown list (data from two columns)

  1. #1
    VBAX Newbie
    Joined
    Jul 2019
    Posts
    2
    Location

    Searchable dropdown list (data from two columns)

    Hi all,
    I am quite new to visual basic and I am trying to get a very specific feature that I don't think it's natively implemented.

    I have two columns ( in two different sheets ) which are supposed to be the base for a dropdown list (in sheet 3). Moreover, I should be able to typing and so simultaneously filter results in the dropdown list (google style, but only if the list item begins with the pattern I am writing). Finally, If the element is not the list, I should be able to add the text to the cell anyway (this last part I think can be achieved simply disabling errors on the validation form).

    Is it possible to obtain a feature like that in vba?

    Thanks in advance,
    Andrea

  2. #2
    VBAX Newbie
    Joined
    Jul 2019
    Posts
    2
    Location
    Quote Originally Posted by kinn View Post
    Hi all,
    I am quite new to visual basic and I am trying to get a very specific feature that I don't think it's natively implemented.

    I have two columns ( in two different sheets ) which are supposed to be the base for a dropdown list (in sheet 3). Moreover, I should be able to typing and so simultaneously filter results in the dropdown list (google style, but only if the list item begins with the pattern I am writing). Finally, If the element is not the list, I should be able to add the text to the cell anyway (this last part I think can be achieved simply disabling errors on the validation form).

    Is it possible to obtain a feature like that in vba?

    Thanks in advance,
    Andrea
    Ok I saw that an ActiveX comboBox match the needs.
    The only question now is if it is possible to merge to column list from two sheets and how it can be implemented using vba

  3. #3
    VBAX Mentor 大灰狼1976's Avatar
    Joined
    Dec 2018
    Location
    SuZhou China
    Posts
    393
    Location
    Hi kinn!
    Welcome to vbax forum.
    Maybe this attachment will help you.
    If you can simulate some data and requirements, it should be able to solve them quickly.
    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
  •