+ Reply to Thread
Results 1 to 3 of 3

ComboBox Rowsource Not Pulling Correctly

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    ComboBox Rowsource Not Pulling Correctly

    My code is supposed to copy a filtered table (excluding headers) onto a temp sheet, remove duplicates, then use that data to populate the new comboboxes. It is copying the filtered values onto the temp sheet and removing duplicates properly. The problem is that I'm seeing some of the headers from the original table in some of the comboboxes (but not all), and I'm also seeing some values that were filtered out in the table in some of the comboboxes (again, but not all).

    So just to clarify, everything works properly until that last block of code. Thank you!!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ComboBox Rowsource Not Pulling Correctly

    Can you upload an example workbook?

    Click on GO ADVANCED and use the paperclip icon to open the upload window.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    04-29-2014
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: ComboBox Rowsource Not Pulling Correctly

    Here is the file.
    Last edited by aearce2000; 06-25-2014 at 11:29 AM.

+ 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] Userform combobox to populate RowSource for new values in combobox
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-17-2013, 01:18 PM
  2. [SOLVED] Combobox value defines Combobox Rowsource
    By onmyway in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-03-2013, 08:57 AM
  3. [SOLVED] Add RowSource to Userform ComboBox based on value on Another ComboBox
    By Baziwan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 01:17 PM
  4. Way to populate combobox rowsource based on previous combobox value
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2012, 12:50 AM
  5. Combobox: How to determine the location of the selected item if combobox has rowsource
    By ahsanzafar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-11-2012, 03:24 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