[發問] VBA ComboBox Group data select vba, combobox is Excel

yabbi

my table on Excel worksheet
Group        Name
1        Sony
1        TAN
2        JOHN
1        SEVEN
2        OKOK
2        MAY
4        ZOO
3        KELVIN
3        KEN
1        STEVEN
4        EVA
1        SANDY

my form code is below
****************************************************************************
Private Sub UserForm_Initialize()
    Dim myAr As Variant
    myAr = Worksheets("Sheet1").Range("A1:b20").Value
    myAr = WorksheetFunction.Transpose(myAr)
    With ComboBox1
        .Width = .Width * 2
        .ColumnCount = 2
        .Column = myAr
    End With
End Sub
****************************************************************************


in this form i need  only slow only 1 Gorup data with column.   
eg. only slow group 1 to choose.

下載 (15.16 KB)
combobox

2012-2-14 15:55

combobox.zip (11.47 KB)

Excel sample
下載次數: 6

2012-2-14 16:02