+ Reply to Thread
Results 1 to 2 of 2

Userform ComboBox ignore Blank Cells in list

  1. #1
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Userform ComboBox ignore Blank Cells in list

    On My userform I have a ComboBox (CboPart) that is populated from a named range determined by previous ComboBox (CboMainframe). The Range encompasses several columns. The first column is what populates the CboPart.
    when the first column's cell is blank, I would like the Cbo list to ignore that cell.

    Here is the code :
    Please Login or Register  to view this content.

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Userform ComboBox ignore Blank Cells in list

    If you want to ignore blanks you will not be able to use the RowSource property.
    Instead you will have to test the cell before using the Additem approach
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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