以下是当前的 VBA 说明。想在末尾添加一条消息,让用户知道宏何时完成,例如“完成”、“完成”或“现在请转到步骤 3”
Sub FORMULA_to_value()
'
' FORMULA_to_value Macro '
' If MsgBox("Are you sure testing is complete because you can not undo this action?", vbYesNo) = vbNo Then Exit
dim MyAddr as string
MyAddr = activesheet.range("D2:D" & Activesheet.cells(rows.count, 4).end(xlup).row).address
答案1
添加MsgBox("Complete")
即可。