+ Reply to Thread
Results 1 to 5 of 5

need advice-combobox drop down list

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    11

    need advice-combobox drop down list

    hi all,
    I had the below entry that i facing problem with the combobox drop down list, my drop down list entry had too many duplicates.
    am i able to get single entry on the dropdown list?
    Can some 1 help me.
    database
    ACER E-HDD D110- USB2.0 1TB
    ACER E-HDD D110- USB2.0 2TB
    ACER E-HDD P110 USB2.0 640GB
    ACER E-HDD P110 USB2.0 750GB
    ACER E-ODD TRAY USB2.0 DVD
    TOSHIBA I-HDD SATA 2.5 sata MK5059GSXP
    TOSHIBA I-HDD SATA 2.5 sata MK5065GSXW
    TOSHIBA I-HDD SATA 2.5 sata MK5075GSX
    TOSHIBA I-HDD SATA 2.5 sata MK5076GSXN
    TOSHIBA I-HDD SATA 2.5 sata MQ01ABD032
    TOSHIBA I-HDD SATA 2.5 sata MQ01ABD050
    TOSHIBA I-HDD SATA 2.5 sata MQ01ABD100
    TOSHIBA I-HDD SATA 3.5 Sata DT01ACA050
    TOSHIBA I-HDD SATA 3.5 Sata DT01ACA100

    VBA as below
    Private Sub UserForm_Initialize()

    With Sheets("Description")
    Brand.RowSource = ""
    Brand.List = .Range("A1", .Range("B" & Rows.Count).End(xlUp)).Offset(, 1).Value
    Brand.ListIndex = 0
    Product.RowSource = ""
    Product.List = .Range("A1", .Range("c" & Rows.Count).End(xlUp)).Offset(, 2).Value
    Product.ListIndex = -0
    series.RowSource = ""
    series.List = .Range("A1", .Range("d" & Rows.Count).End(xlUp)).Offset(, 3).Value
    series.ListIndex = -0
    interface.RowSource = ""
    interface.List = .Range("A1", .Range("c" & Rows.Count).End(xlUp)).Offset(, 4).Value
    interface.ListIndex = -0
    End With
    End Sub

  2. #2
    Registered User
    Join Date
    04-29-2013
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: need advice-combobox drop down list

    Partnos.xlsm
    above is the sample of my file

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: need advice-combobox drop down list

    any helper?

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,314

    Re: need advice-combobox drop down list

    maybe so
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: need advice-combobox drop down list

    Hi,

    I inserted some additional code to the userform, is that what you wanted: Partnos.xlsm
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

+ Reply to Thread

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