ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] VBA ComboBox Group data select

[µo°Ý] VBA ComboBox Group data select

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.

combobox.jpg


combobox.zip (11.47 KB)

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD