- Sub 单号自动变化B() '
- s$ = 窗体.ComboBox8
- i% = Right(s, 4) * 1
- y% = 6
- Do While Not Sheet1.Range("C2:C65535").Find(s) Is Nothing
- i = i + 1
- s = Left(s, Len(s) - 4) & Right("0000" & i, 4)
- Loop
- If s$ <> 窗体.ComboBox8 Then y = MsgBox("发现重复编号:" & 窗体.ComboBox8 & ",将生成新编号:" & s & "进行保存。", vbYesNo)
- If y = vbYes Then
- 窗体.ComboBox8 = Left(s, Len(s) - 4) & Right("0000" & i + 1, 4)
- Else
- End
- End If
- 'If y = 6 Then Sheet2.[s65536].End(xlUp)(2, 1) = s'
-
- End Sub
复制代码 |