|
发表于 2014-3-5 12:11
|
显示全部楼层
本楼为最佳答案
我感觉你把简单问题复杂化了.
用range.find就行了.- Private Sub ComboBox1_Change()
- TextBox1.Text = Sheet1.Range("a:a").Find(ComboBox1.Text, , , xlWhole, , xlPrevious).Offset(, 1).Value
- End Sub
- Private Sub CommandButton1_Click()
- Sheet1.Range("a:a").Find(ComboBox1.Text, , , xlWhole, , xlPrevious).Offset(, 1).Value = TextBox1.Text
- ComboBox1 = ""
- TextBox1 = ""
- End Sub
- Private Sub UserForm_Initialize()
- ComboBox1.RowSource = "sheet1!a2:a" & Sheet1.Range("a65536").End(xlUp).Row
- End Sub
复制代码 |
|