|
请老师们帮忙:
先谢过老师们!
我的窗体上有ComboBox1和TextBox1,表Sheet2为数据。当打开窗体,点击窗体的ComboBox1,选中某个单位时,TextBox1则自动显示表Sheet2中该单位的流水号的最后一个号+1。(也就是生成一个的流水号)
这样的效果?
- Private Sub ComboBox1_Change()
- Dim C As Range, Ar
- With Sheets("Sheet2")
- Set C = .Range("B:B").Find(Me.ComboBox1.Value, , , 1, , 2)
- If C Is Nothing Then
- MsgBox "数据: " & Me.ComboBox1.Value & " 未找到!!", , "错误"
- Exit Sub
- Else
- Ar = Split(C.Offset(, 1).Value, "Y")
- Me.TextBox1.Value = Ar(0) & "Y" & Ar(1) + 1
- End If
- End With
- End Sub
复制代码
|
|