Results 1 to 14 of 14

Search function within Form Control ComboBox

Threaded View

esbencito Search function within Form... 10-12-2017, 12:48 AM
nilem Re: Search function within... 10-12-2017, 12:51 AM
esbencito Re: Search function within... 10-12-2017, 01:57 AM
nilem Re: Search function within... 10-12-2017, 07:36 AM
esbencito Re: Search function within... 10-13-2017, 12:19 AM
nilem Re: Search function within... 10-13-2017, 01:03 AM
esbencito Re: Search function within... 10-13-2017, 01:59 AM
nilem Re: Search function within... 10-13-2017, 02:27 AM
esbencito Re: Search function within... 10-13-2017, 02:43 AM
nilem Re: Search function within... 10-13-2017, 03:17 AM
esbencito Re: Search function within... 10-13-2017, 03:34 AM
nilem Re: Search function within... 10-13-2017, 07:06 AM
esbencito Re: Search function within... 10-13-2017, 11:15 PM
esbencito Re: Search function within... 12-07-2017, 04:22 AM
  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Search function within Form Control ComboBox

    Hi all,

    Is there a way to add a search function to a Form Control ComboBox by using a VBA code? As it seems, such function does not originally exist within Excel. Basically, As illustrated in the image below, I need to search for a particular store (1500+ stores available).

    E.g. If I start typing "Ocean Terminal Hon" it automatically suggest all stores which consist of "Ocean Terminal Hon" such as store "Ocean Terminal Hong Kong".

    Is that even feasible within Excel?
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combobox (Form Control, not ActiveX) Disappears. Help!
    By ilsley_excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2015, 06:39 AM
  2. form control combobox font size in vba
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2014, 11:08 AM
  3. Validation or ComboBox ActiveX/Form Control...
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-20-2014, 01:10 PM
  4. [SOLVED] Need to get Value from ComboBox Form Control
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2013, 09:06 AM
  5. Macro to filter data to search terms selected from ComboBox (Form Control)
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2013, 05:08 PM
  6. Delete values in a Combobox (Form Control)
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2013, 08:20 AM
  7. [SOLVED] Apply form control containing macro to a combobox
    By kamaaina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2013, 12:47 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