以下是当前的 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
添加
MsgBox("Complete")会做到这一点。