標題: [發問] VBA ComboBox Group data select [打印本頁] 作者: yabbi 時間: 2012-2-14 16:03 標題: 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.
