+ Reply to Thread
Results 1 to 4 of 4

Remove duplicates and blanks from Combo Box Excel Userform?

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    9

    Remove duplicates and blanks from Combo Box Excel Userform?

    Hello,

    I have a userform in my workbook. The userform includes a combo box that relates to an offset range in my main data worksheet. The offset range ("UsedHoldNumber_") is written as: =OFFSET(MAIN!$D$4,0,0,COUNTA('Hold Number'!$D:$D))

    I have the following vba written in my userform initialize section:

    Please Login or Register  to view this content.

    How can I make this hide duplicate values and blanks from the combo box?

    Thanks in advance,

  2. #2
    Forum Contributor
    Join Date
    07-27-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2003
    Posts
    196

    Re: Remove duplicates and blanks from Combo Box Excel Userform?

    One method is to build an array of unique values and
    then populate the combo box from that array. Here's an example
    where values are in column 1, beginning in cell A1:
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Remove duplicates and blanks from Combo Box Excel Userform?

    Try
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-22-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Remove duplicates and blanks from Combo Box Excel Userform?

    Jindon, you code worked perfectly Thanks!

+ 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. VBA combo boxes (ignore blanks + avoid duplicates)
    By pbobadilla in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2012, 05:44 PM
  2. How to remove duplicates in excel file
    By uday1969 in forum Excel General
    Replies: 13
    Last Post: 06-14-2012, 03:13 PM
  3. Excel remove blanks from list
    By evs1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2012, 12:33 PM
  4. Excel 2007 : Remove Duplicates in excel (conditional)
    By bhanu143143 in forum Excel General
    Replies: 0
    Last Post: 09-14-2011, 02:59 PM
  5. Remove duplicates from excel
    By shaila in forum Excel General
    Replies: 1
    Last Post: 11-07-2008, 05:39 AM

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