Bounce a note when you press a macro button

Copper Contributor

Hi,

I created a macro button that works fine, but since after running a macro there is no possibility to use CTRL+Z, I'm looking for an option to bounce a note when the macro button is pressed, just before the macro goes into action.

3 Replies

@Netali_T 

 

I take it you want a popup confirmation message?

 

Sub temp()
     Const msgWarning = "Actions performed by macro cannot be undone. Continue?"
     
     If MsgBox(msgWarning, vbYesNo + vbExclamation) = vbNo Then
          Exit Sub
     End If
     
End Sub

@JMB17 

 

Yes thank you!

Works great :)

You are welcome.