+ Reply to Thread
Results 1 to 2 of 2

Activex ComboBox affecting Advanced Filter Macro

  1. #1
    Registered User
    Join Date
    04-18-2016
    Location
    england
    MS-Off Ver
    MS Version 2010
    Posts
    1

    Activex ComboBox affecting Advanced Filter Macro

    HI,

    I have a database of suppliers and their skill set on Tab one ( "full comb List") and then on Tab 2 ( "search engine" ) I have created 5 Excel activex combobox Drop Down list with Search Suggestions. so that the user can select a certain criteria and the advanced search will then show suppliers that meet these criteria.

    I have then created the following piece of VBA code for each box to make them dynamic.

    Please Login or Register  to view this content.
    Once this has been done for each ComboBox I have then recorded a separate macro for an Advance Search

    Please Login or Register  to view this content.
    The issue is when I then run the macro by selecting a criteria from the dropdown list the macro Either gets stuck on the "full comb List" tab or doesn't display the required data on the "search engine" it just displays the column headers and not the data.

    If I perform the advance search without the macro or with out the activex combobox then it works perfectly.

    Any ideas, im relatively new to coding etc and have been searching for a solution for a couple of days now?

    Thanks in Advance!

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

    Re: Activex ComboBox affecting Advanced Filter Macro

    Could you attach your sample workbook (without sensitive data).
    If you're having trouble using the attachment, please read this info:
    http://www.excelforum.com/showthread.php?t=1128657

+ 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] fill listbox (ActiveX) based combobox (ActiveX)
    By elsg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2014, 11:25 AM
  2. Macro assign to ActiveX Combobox
    By kangsongwu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2014, 02:56 AM
  3. Replies: 5
    Last Post: 12-19-2013, 06:58 AM
  4. ActiveX combobox in spreadsheet re-sizes each time the macro runs
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2013, 12:43 PM
  5. Combobox - Filter auto-filter worksheets (ActiveX)
    By Darms in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2011, 11:33 AM
  6. Double advanced filter and combobox population
    By Andrew-Mark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2010, 06:26 PM
  7. Userform: Make a advanced filter script "filter" when a combobox is altered
    By Zheno in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-09-2010, 04: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