|
本帖最后由 望帝春心 于 2016-11-30 15:51 编辑
- Private Sub UserForm_Initialize()
- Dim arr(), i&
- i = Sheets("sheet1").[E65536].End(xlUp).Row - 7
- ReDim arr(1 To i, 1 To 1)
- brr = Sheets("sheet1").[E7].Resize(Sheets("sheet1").[E65536].End(xlUp).Row - 7, 3)
- For j = 1 To i
- arr(j, 1) = brr(j, 1) & " " & brr(j, 3)
- Next
- ComboBox1.List = arr
- End Sub
复制代码 简单改了下你的代码 |
|