Adding a Message box for confirmation VB Excel 2003

Adding a Message box for confirmation VB Excel 2003

I was sent by someone some awesome code but they are way to complex for me to play around in as they do multiple tasks in one code.

I have the following code in one of my worksheet:

Please Login or Register  to view this content.

I need help in adding something to this code:

If “yes” is selected then add a msgbox to say the following:

This will be transfer to MERX.

Instead of “yes” and “Cancel” it would need to say “Accept” and “Cancel”

If “Accept” is selected then run Script, if “Cancel” is selected then do nothing.

Can someone help me?

It works perfecaly xladept Thank you.

Is there a way to add more to it or will I need to creat a sort of form...

Example:

Please Login or Register  to view this content.

But instead of having vbYesNo to have "Accept" or "Cancel"

If "Accept" is clicked then proceed with the code and;
If "Cancel" is clicked then do nothing only clear Cells(Target.Row, 13)).ClearContents

I think I found the end result :D

Thanks for all the help

Here is the code:

Please Login or Register  to view this content.

I will just need to figure out the vbYesNo + vbCritical to change it to Accept and Cancel.