Results 1 to 2 of 2

Add an Additional Filter to ComboBox1

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2015
    Location
    Houston, TX
    MS-Off Ver
    MS 2010
    Posts
    5

    Add an Additional Filter to ComboBox1

    Hi all,
    I have the following code below that provides me a combobox with unique values; however, I'd like to be able to add an additional filter from column A such as showing only values that have been added or moved instead of all of them.
    Thanks for your help.

    Private Sub UserForm_Initialize()
    Dim myCollection As Collection, cell As Range
    On Error Resume Next
    Set myCollection = New Collection
    With ComboBox1
    .Clear

    'loop thru
    For Each cell In Range("O18:O" & Cells(Rows.Count, 15).End(xlUp).Row)

    If Len(cell) <> 0 Then
    Err.Clear
    myCollection.Add cell.Value, cell.Value
    If Err.Number = 0 Then .AddItem cell.Value
    End If

    Next cell

    End With

    End Sub
    Last edited by ckoolsurf; 03-23-2015 at 11:21 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Filter issue when adding additional data
    By msmetal in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-08-2014, 09:53 AM
  2. Replies: 4
    Last Post: 03-05-2014, 02:40 AM
  3. Replies: 1
    Last Post: 02-06-2014, 03:00 PM
  4. I need to add an additional option in CUSTOM FILTER
    By japorms in forum Excel General
    Replies: 3
    Last Post: 04-27-2006, 08:56 AM
  5. Filter list on additional worksheets
    By Annabelle in forum Excel General
    Replies: 2
    Last Post: 06-30-2005, 08:05 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