How do I include in a macro the simple option of "YES" or "NO" buttons?

[Kroonarend]

In a specific worksheet, I would like to include the options of :-
“Are you sure you want to clear the Information?”
Then, by selecting the “NO” button, it should return the focus back the the active worksheet. Should
“YES” be selected, it should execute the remainder of the macro.

I have no experience with macros or programming, and when looking at the dialog of the recorded macros that I do have, it appears to be from another planet. If someone can assist with the dialog that could create the buttons as well as the execution of the options, I would really appreciate it.

Thanks

[JohnSUN]

Just try to use MsgBox. It can’t be written with macro recorder. You must write manually something like as

If MsgBox("Text of description", 4, "Title") = 6 Then 
    ... do if Yes ...
Else
    ... do if No or close dialog ...
End If

What is 4 and 6 see by link above