Results 1 to 5 of 5

Combobox add item not listed yet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-26-2006
    Posts
    189

    Combobox add item not listed yet

    I have the following code that is suposed to add items to a combobox from a excel column:
    Private Sub UserForm_Initialize()
    With ComboBox1
    For Row = 6 To 3000
    If IsEmpty(Folha1.Cells(Row, 3)) Then
        GoTo Saida
        Else
        .AddItem Folha1.Cells(Row, 3)
    End If
    Saida:
    Next Row
    End With
    End Sub
    My problem is that in the selected column ("C") i have the same value more than once. So i want it to not repeat it in the droplist.
    How can i do it?

    Thanks!!
    Last edited by mqdias; 02-15-2012 at 12:41 PM.

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