+ Reply to Thread
Results 1 to 2 of 2

Populating a listbox or comobox (validation?) with unique values from large range

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Populating a listbox or comobox (validation?) with unique values from large range

    Hi all,
    I'm having difficulty solving this one. Any suggestions would be appreciated.

    For each row on Sheet1, I need to gather an array based on a [partial] cell value lookup to a column on Sheet2.

    For example, Sheet1!A2 might the value "Cinnamon Applesauce". I'm extracting the first word of this string ("Cinnamon") and I need to pull all values from Sheet2!J:J that include the word "Cinnamon". So, something like {"Cinnamon sugar", "Cinnamon sticks", "Apple Cinnamon"}
    It would be nice if I could put these into a validation combobox on Sheet1 (one per row.)

    Also, my worksheets are very large, so speed is a concern.

    Thanks for your input.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Populating a listbox or comobox (validation?) with unique values from large range

    This should be pretty quick: (creates validation box in cell A1)

    Please Login or Register  to view this content.
    Edit: Please use edited code. It adjusts for multiple run applications.
    Last edited by stnkynts; 12-12-2013 at 11:45 PM.

+ 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] VBA Userform: Use value from Comobox to populate a Listbox
    By devolg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2013, 11:59 PM
  2. Populating listbox with unique values
    By protocol in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-17-2011, 08:44 AM
  3. Listbox of Unique Records populating another listbox
    By web2xs in forum Excel General
    Replies: 1
    Last Post: 04-16-2009, 11:27 PM
  4. Replies: 9
    Last Post: 07-30-2006, 04:10 AM
  5. Populating a listbox with values from a sheet.
    By shenlingstyle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2005, 04:20 PM

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