+ Reply to Thread
Results 1 to 10 of 10

Combobox unique dropdown from list with duplicate values error

  1. #1
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Combobox unique dropdown from list with duplicate values error

    Hi and thanks for looking. I have uploaded my workbook to make it easier to demonstrate my issue.

    I have placed a combobox in the "summary" tab. I would like to be able to select unique values from column B of the "Engage 2014" tab. (the range in Col B B will grow each week)

    I have place the code below in a module but.... to no avail!! could someone offer any advice? Many thanks

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Blake 7; 11-12-2014 at 06:38 AM.
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Combobox unique dropdown from list with duplicate values error

    I do not see where the user form or control are on your sample.
    The code errors on this line

    If .Count Then Sheets("Engage 2014").ComboBox1.List

    as there is no ComboBox1.List either on the sheet or user form.

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

    Re: Combobox unique dropdown from list with duplicate values error

    Accidental duplicate.
    Last edited by Norie; 11-12-2014 at 06:21 AM.
    If posting code please use code tags, see here.

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

    Re: Combobox unique dropdown from list with duplicate values error

    The only combobox in the workbook is ComboBox1 on the sheet 'Summary'.

    If that's the one you want to populate with unique values change the code to refer to that sheet.

    Also clear the ListFillRange of the combobox.

    Please Login or Register  to view this content.
    You might also want to put this in Summary's module.
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Combobox unique dropdown from list with duplicate values error

    Hi and thanks for looking - I found this code on the tinternet and tried to adapt it... I have no user form, just a combobox in the summary tab.

    The range I would like to select the unique values from is called combolist but this will grow each week..

    Does that help? cheers

  6. #6
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Combobox unique dropdown from list with duplicate values error

    Hi Norie - thanks for looking, I'll have a bash now and report back. Thanks again for your time.

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

    Re: Combobox unique dropdown from list with duplicate values error

    This will take care of expanding data.
    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Combobox unique dropdown from list with duplicate values error

    Please Login or Register  to view this content.

  9. #9
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Combobox unique dropdown from list with duplicate values error

    Hey Guys - great stuff, its working fine now. Many many thanks for your help it's really much appreciated.

  10. #10
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Combobox unique dropdown from list with duplicate values error

    Norie - thanks for the second bit which takes care of expanding date - just tried it out, perfect.

+ 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. Dropdown list always shows unique values from a column based on lookup value
    By swood15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2014, 12:46 PM
  2. [SOLVED] ComboBox - "Error: Invalid Property Used" while restricting the dropdown values
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-05-2013, 04:26 AM
  3. Validation rule dropdown list without duplicate values
    By sakinen in forum Excel General
    Replies: 9
    Last Post: 05-08-2013, 08:56 AM
  4. Dropdown List without Duplicate Values
    By s_lemin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2007, 01:13 PM
  5. how to populate a combobox with a list of unique values?
    By RIOSGER in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2005, 12:05 AM

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