+ Reply to Thread
Results 1 to 3 of 3

How to create Search Suggestion ComboBox in USERFORM

  1. #1
    Registered User
    Join Date
    01-24-2015
    Location
    Singapore
    MS-Off Ver
    office365
    Posts
    16

    How to create Search Suggestion ComboBox in USERFORM

    I am really pulling my hear to think about how to get “Search Suggestion ComboBox in USERFORM”

    What I searched over Google get the following one awesome tutorial, but it is for ActiveX Control in the Worksheet.
    https://www.youtube.com/watch?v=Gm5m-y49rI0

    I am relatively new here, I am not sure whether this is workable for Combobox or not , if yes, really appreciate you can help me about it.

    Thank you so much !

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: How to create Search Suggestion ComboBox in USERFORM

    Search UserForm.xlsm
    Maybe this can get you started...
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    01-24-2015
    Location
    Singapore
    MS-Off Ver
    office365
    Posts
    16

    Re: How to create Search Suggestion ComboBox in USERFORM

    Thank you for your reply.

    I am sorry, I don’t think I make myself clear for what I want.

    What I want is a ComboBox in the Userform with the searchable and suggestion function,
    For example, when I key the letter “a”, the ConboBox dropdown all those items contains with”a”
    e.g.
    Current Asset
    Fix Asset
    Account receviables
    Bad Debts

    Thank you so much!

+ 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. Search as you type Combobox Excel Userform
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2017, 02:51 PM
  2. how to create search suggestion drop down list in mac excel
    By sumit978 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-07-2015, 02:52 AM
  3. using userform textbox to search instead of combobox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2013, 02:06 PM
  4. [SOLVED] VBA code to search using userform with multiple combobox's
    By goffa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-18-2013, 07:43 AM
  5. Userform & ComboBox to search a Workbook
    By StevenM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2012, 03:01 AM

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