Message box code

[chiidzzz]

Hello,
I have a code already written to execute an operation in a selected sheet. (sheet 23)
I need help writing a code in a message box.
If I enter in column L (in sheet 23) the word "BAB", the code should show me the message box saying: "Are you sure about the information?" with 2 options below "YES" and "NO".
If I select yes, I want it to execute my code.
If I select no, I want it to only make the message box diasppear, without executing anything.
Thanks for your help.

[jraj1106]

Hi.

Try this code:

Please Login or Register  to view this content.

[RHCPgergo]

Hi,

copy this to the Worksheet module of Sheet 23.

Please Login or Register  to view this content.

[chiidzzz]

Sorry if I didn't make myself clear enough.
The code I already have is activated when selecting "BAB" in any row of the column L

Please Login or Register  to view this content.

What I need to do is to create a message box that appears when I select in column L the word "BAB" to let me confirm that the information entered are true. If I select Yes, I want it to execute the previous code, and if I select No, I want it to dismiss the message without doing anything so I can edit my information again.
Thanks

[RHCPgergo]

Please Login or Register  to view this content.

[jraj1106]

Check this:

Please Login or Register  to view this content.

[chiidzzz]

Thanks alot, it works perfectly

[chiidzzz]

When I select NO, the code execution stops, but the word in column L stays (BAB). How can I clear it?

[jraj1106]

I have included the code for clearing col L. Check the above code that I had posted previously.Its just this:

Please Login or Register  to view this content.

[chiidzzz]

Thank you for your help

[RHCPgergo]

Please Login or Register  to view this content.

[jraj1106]

You are welcome.