Private Sub UserForm_Initialize()
Dim i%, arr
arr = Sheets("交易记录").Range("E6:H6")
With Me.ComboBox1
For i = 1 To UBound(arr, 2)
.AddItem arr(1, i)
Next
.AddItem Sheets("交易记录").Range("H9")
.Text = arr(1, 1) '去第一个值为默认批注,并全选,方便录入没有的批注内容
.SelStart = 0
.SelLength = Len(.Text)
.SetFocus
End With
End Sub 取拐弯区域的数据2.rar(20.11 KB, 下载次数: 3)