Results 1 to 2 of 2

population list box without repeating information

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2004
    Location
    Georgia
    Posts
    57

    populating list box without repeating information

    ok, so i used the code below to fill a list box:

    Private Sub UserForm_Initialize()
    
        Dim oIngredient As Ingredient
        Dim oIngredients As New Ingredients
        Dim avIngredients() As Variant
        Dim i As Integer
        
        For i = 1 To oIngredients.Count
            Set oIngredient = oIngredients.Item(i)
            avIngredients(i) = oIngredient.IngredientType
            If oIngredient.IngredientType= previoustype Then          ' need something here
                GoTo Skip
            Else
                Me.lstPreDefinedTypes.AddItem (CStr(oIngredient.IngredientType))
            End If
    Skip:
        Next i
        
    End Sub
    well, not exactly; the "oIngredient.Type = previoustype" needs to be replaced with something that will look through the array being filled and return true if it finds a duplicate.
    is there a way to do this?

    thanks ahead of time,
    sven
    Last edited by medicenpringles; 10-23-2005 at 10:17 PM.
    Brought to you by Pringles and his infinite genius. ~''~

    "Ctrl+Z is a beautiful thing."
    - Me.

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