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
Bookmarks