Results 1 to 8 of 8

looping over combobox names

Threaded View

  1. #1
    Registered User
    Join Date
    08-27-2007
    Posts
    48

    looping over combobox names

    Hi,
    I've got 20 comboboxes in a sheet, named CmbGarmentID1, CmbGarmentID2 etc. They've all got to have the same items listed. Currently, the code doing this is:

    Do Until Sheets("ListOfGarments").Range("B" & i) = "" Or i > i_max
                Sheets("GarmentMeasts").CmbGarmentID1.AddItem (Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i))
                Sheets("GarmentMeasts").CmbGarmentID2.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID3.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID4.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID5.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID6.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID7.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID8.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID9.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID10.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID11.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID12.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID13.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID14.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID15.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID16.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID17.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID18.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID19.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID20.AddItem Sheets("ListOfGarments").Range("B" & i) & " " & Sheets("ListOfGarments").Range("D" & i)
            i = i + 1
         Loop
    It works,. but it's clunky.

    Is there a way of looping over the names of the combo boxes? I've tried looping over j and coding things like

    "Sheets("ListOfGarments").Range("D" & i)
                Sheets("GarmentMeasts").CmbGarmentID" & j & ".AddItem"
    but so far, have not got it to work. Any suggestions would be most welcome.

    Lotte
    Last edited by Leith Ross; 11-18-2007 at 09:02 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