Message Box, Are you sure you meant to execute the macro?

I have the following code that copies and pastes data. After the button is clicked and before the macro is executed I would like a message box to pop up with "Are you sure you mean to export as (text within Calculator!AJ2)" and a yes or no option.

What is the appropriate lines of code to do that?

Thank you much.

Please Login or Register  to view this content.

try this addition

Please Login or Register  to view this content.

Attachment 706404

I get a Compile error: User-defined type not defined, at the pictured line of code.

It should be

Please Login or Register  to view this content.

or get rid of the variable & just use

Please Login or Register  to view this content.

It works, thank to both of you.

Glad to help & thanks for the feedback.