修改以下宏
Private Sub DTPicker1_Change()
s$ = "EXCEL" & Format(DTPicker1, "yyyy-mm-dd") & "-0001"
Do While Not Sheet2.Range("s:s").Find(s) Is Nothing
i = i + 1
s = Left(s, Len(s) - 4) & Format(i, "0000")
Loop
ComboBox1 = s
End Sub
修改以下宏
Private Sub DTPicker1_Change()
s$ = "EXCEL" & Format(DTPicker1, "yyyy-mm-dd") & "-0001"
Do While Not Sheet2.Range("s:s").Find(s) Is Nothing
i = i + 1
s = Left(s, Len(s) - 4) & Format(i, "0000")
Loop
ComboBox1 = s
End Sub