|
本帖最后由 老司机带带我 于 2016-8-3 13:52 编辑
以下代码防止放置中,按钮自己指定以下宏:- Sub xx()
- Dim n%, i%, s$
- For i = 4 To Cells(Rows.Count, 1).End(xlUp).Row
- If Cells(i, 1).Value = "最后报名日" Then
- n = n + 1
- s = s & n & "、序号" & Cells(i, 2) & ",日期" & Cells(i, 3) & ",项目名称" & Cells(i, 2) & ";" & Chr(10)
- End If
- Next
- s = "今日共应报名" & n & "个" & Chr(10) & s & Chr(10) & "以上项目请尽快报名!"
- MsgBox s
- End Sub
复制代码 |
|