|
发表于 2013-6-11 18:21
|
显示全部楼层
本楼为最佳答案
- Private Sub ComboBox1_Change()
- For i = 1 To Col末列号
- If ComboBox1.Text = Cells(1, i) Then
- Row末行号 = Cells(Rows.Count, i).End(xlUp).Row
- If Row末行号 = 2 Then
- ReDim Arr临时数组(1 To 1)
- Arr临时数组(1) = Cells(2, i)
- Else
- Arr临时数组 = Application.Transpose(Range(Cells(2, i), Cells(Row末行号, i)))
- End If
- Exit Sub
- End If
- Next
- End Sub
- Private Sub CommandButton1_Click()
- Dim str$
- For k = 1 To UBound(Arr临时数组)
- str = str & "arr(" & k & ")=" & Arr临时数组(k) & vbCrLf
- Next k
- MsgBox str
- End Sub
复制代码 |
|