+ Reply to Thread
Results 1 to 5 of 5

Searchable combo-box in user-form

  1. #1
    Registered User
    Join Date
    08-25-2021
    Location
    Kuching, Malaysia
    MS-Off Ver
    2016 32bits
    Posts
    30

    Searchable combo-box in user-form

    Hi expert,

    I have user form with dependant combo boxes 1 (txtProblem) . In which this combo box will list down data based on combo box 2 (txtMachine). I want vba or macro to make combo boxes 1 (txtProblem) searchable just like google search suggestion based on combobox 2 (txtMachine)
    Please see attached file.
    ex. Sheet 3 is where the data for combo box

    Please help me if have any way to make it searchable.

    Thank you for advance help.

  2. #2
    Registered User
    Join Date
    06-02-2018
    Location
    Italy
    MS-Off Ver
    2013-2019
    Posts
    31

    Re: Searchable combo-box in user-form

    It seems that the columns of sheet 3 have no relationship to each other.
    What is the relationship between Machine and Problems?

    For example,
    - what values should be listed with Machine DIFFUSION ?
    - what values should be listed with Machine SELA ?
    - what values should be listed with Machine ANNEALING ?

  3. #3
    Registered User
    Join Date
    08-25-2021
    Location
    Kuching, Malaysia
    MS-Off Ver
    2016 32bits
    Posts
    30

    Re: Searchable combo-box in user-form

    The relationship is like this
    Attachment 747605

    The txtTube list will be depend on txtMachine
    example: txtMachine is Diffusion, and on the txtTube it will show all the Diffusion Machine
    ----------------------------------------------------------------------------------------------
    What i'm trying to achieve here is to do a searchable combobox inside txtProblem which depend on the txtMachine
    The data for txtProblem is under "Diffprob,Aldprob,printprob etc"

    example1: txtMachine is Diffusion, then under txtproblem it will show "diffprob data" and as we type in the combobox (txtproblem) it will do a searchable just like google search suggestion (diffprob data)

    example2: txtMachine is Sela, then under txtproblem it will show "aldprob data" and as we type in the combobox (txtproblem) it will do a searchable just like google search suggestion (aldprob data)

    i hope i make it clear

    Below is an example of searchable combobox that i would like to do
    The combobox will dropdown some suggestion as we type
    Last edited by Cyril Beki; 09-14-2021 at 07:02 AM.

  4. #4
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    995

    Re: Searchable combo-box in user-form

    Hi, Cyril Beki
    I suggest you don't use 'rowsource' to populate the combobox list , because it's unreliable, sometimes it makes the Excel crash.
    Please check this:
    http://www.snb-vba.eu/VBA_Fill_combobox_listbox_en.html
    "If you use 'rowsource' you make a direct link to a certain range in a worksheet.
    Combined with the combobox it can cause Excel to blackout, because any change in the combobox will be transferred directly to the 'source'.
    Excel has proven not to be able to do this correctly.
    Besides: the changing of the source at every change in the combobox slows down your code.
    You should reduce the reading/writing from/to a workbook in your code as much as possible."

    and this:
    https://www.excelforum.com/excel-pro...ml#post5211269

    You can populate the combobox like this:
    Please Login or Register  to view this content.
    OR
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-25-2021
    Location
    Kuching, Malaysia
    MS-Off Ver
    2016 32bits
    Posts
    30

    Re: Searchable combo-box in user-form

    what about the searchable combobox ? Because i really need it since it will quicken my time to pick any required data

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [USERFORM] Dynamic searchable user form.
    By thebeastslayer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2020, 05:54 AM
  2. Populate text boxes on user form, from combo box on same user form
    By Richardswaim in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-03-2016, 09:35 AM
  3. [SOLVED] Combo box in a user form
    By fazthfc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-01-2015, 10:25 AM
  4. User form combo box
    By slickz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2014, 09:02 AM
  5. combo box user form code for two combo boxes
    By robert.begley1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-01-2012, 02:25 PM
  6. [SOLVED] combo box in a user form
    By juliejg1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2006, 04:20 PM
  7. Can't seem to get Combo Box on User Form
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2005, 07:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1