Results 1 to 2 of 2

Stop duplication in a combo box

Threaded View

  1. #1
    Registered User
    Join Date
    01-02-2012
    Location
    Ebbw Vale
    MS-Off Ver
    Excel 2007
    Posts
    20

    Stop duplication in a combo box

    hi,
    below is my code which i have for a drop down list within my userform...
    i have been asked to select a name from a listbox then use the combo box to select a "mr" "miss" etc to them show up together in a label.

    the problem i have is that every time i click on the drop down it duplicates the list that is already there,,
    could someone please advise of a way to stop this

    thank you


    Private Sub comList_DropButtonClick()
    With comList
        comList.AddItem "Miss"
        comList.AddItem "Mrs"
        comList.AddItem "Mr"
        comList.AddItem "The Awesome"
        comList.AddItem "Doctor"
        comList.AddItem "The Incredible"
    End With
    End Sub
    Last edited by 10121730; 02-01-2012 at 06:53 PM. Reason: changing to solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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