+ Reply to Thread
Results 1 to 3 of 3

VBA - Filtered combobox

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    belgium
    MS-Off Ver
    2013
    Posts
    22

    Question VBA - Filtered combobox

    hi,

    i have a excel table looking like this

    product A, active
    product B, not active
    product C, active
    product D, active


    to populate a combobox on a userform, i use the following code
    Please Login or Register  to view this content.
    This populates the combobox with product A, B, C, D.
    However, i would like to populate the combobox with only the active products, so only A, C and D.

    I have no idea how to adjust the code.
    can anyone help?
    Last edited by Leith Ross; 04-03-2015 at 02:00 AM. Reason: Added Code Tags

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA - Filtered combobox

    Hello verschelde.steven,

    You need to check 9if the product is active or not before adding it to the ComboBox.

    If the product is a string that contains the status "active or "not active" then use this code...
    Please Login or Register  to view this content.

    If the product and it's status are in separate cellsthen use this code...
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-25-2014
    Location
    belgium
    MS-Off Ver
    2013
    Posts
    22

    Re: VBA - Filtered combobox

    Thanks, works perfectly !

+ 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. Combobox filtered with textbox; Listview filtered by combobox
    By Arvin.Amaro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2015, 11:48 AM
  2. [SOLVED] Excel VBA - Issue in Naming Filtered Range on a Filtered List.
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2014, 01:17 PM
  3. Load Userform ComboBox with filtered data
    By anandvh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2012, 05:34 PM
  4. Filtered content in the drop-down list of Combobox
    By saschagraef in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-08-2010, 05:25 AM
  5. [SOLVED] Fill ComboBox with Filtered Data
    By jeffagin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-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