+ Reply to Thread
Results 1 to 2 of 2

Populate Listbox based on Combobox selection

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    south africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Populate Listbox based on Combobox selection

    Hi all,

    I hope someone can help me.

    My table contains 26 columns, I have Column E header as 'Assignee' and Column J for 'Date_Closed'.

    I have a form containing a combobox and a listbox. The combobox is populated with 10 Assignee Names.

    I want the listbox to be populated with all rows containing the selected Name ONLY if Date_Closed column (J) is blank/null.ie.date not filled yet.

    For example, if i select "Ann", the listbox will show all rows in the table that have Assignee Ann for and closed date is still blank.

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Populate Listbox based on Combobox selection

    Upload your workbook...
    ________________________________________________________
    If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.

    Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.

+ 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. Populate textbox based off ComboBox Selection
    By ladams41 in forum Excel General
    Replies: 1
    Last Post: 04-09-2014, 10:13 AM
  2. Populate TextBox based off ComboBox selection
    By ladams41 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2014, 01:24 PM
  3. Userform Combobox to populate based on selection in another combobox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 03:34 PM
  4. [SOLVED] Automatically Populate Listbox from ComboBox Selection
    By doglover in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2013, 01:51 AM
  5. populate listbox based on selection in previous listbox
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2007, 10:55 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