+ Reply to Thread
Results 1 to 1 of 1

Unsolicited dropdown list from combo box

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Adelaide
    MS-Off Ver
    Excel 2019
    Posts
    79

    Unsolicited dropdown list from combo box

    G'day Excel Forum

    I’ve been following a method I found on the net for building a search bar with suggestions drop-down (like a Google search), described here; http://trumpexcel.com/tag/excel-search/

    It’s worked quite well however I am having a small issue with it;

    Weirdly whenever I click on any button, tick any check-box or hit enter after typing anything elsewhere in my sheet, the search suggestions box I’ve built using this method drops down (the attachment may make this clearer).

    I’ve been discussing it with a very knowledgeable forum moderator while working on this worksheet however we’re both stumped.

    Has anyone any idea why it might be doing this? Could it perhaps be clashing with another code or have something to do with the version of excel I'm using (2010)?

    Would appreciate any insight you'd have

    Regards

    MattRNR

    P.S. The helper columns and data can be found on the database sheet.
    Attached Files Attached Files

+ 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. [SOLVED] Combo DropDown List is moving after text selection
    By suchetherrah in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2015, 09:38 PM
  2. how to add a Dropdown list in combo box (Active x control)
    By kasun in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2014, 04:47 AM
  3. Activate dropdown list in combo box by single click
    By ligerdub in forum Excel General
    Replies: 2
    Last Post: 08-30-2012, 10:41 AM
  4. Replies: 0
    Last Post: 08-22-2012, 03:52 PM
  5. Dynamic dropdown list selection based on combo box
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2012, 10:55 AM
  6. combo box dropdown list
    By pczmut in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-29-2006, 10:15 AM
  7. [SOLVED] Combo Box List Dropdown
    By HornJM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2006, 05:15 PM

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