Message Box when is cell text is "YES" or "NO" !

[headgaar]

Hi, all. Newbie here. I don't know how to do something, so i need your help

As you can see in the image i have a list from cell C3 to cell C11 with the text "yes" and "no". What i liked to do is when i choose "YES" a message box would show saying "Congratulations!". For the "NO" i don't want any message box to show. This must be very simple for you, but for me it isn't

Sem título.jpg

[xladept]

Hi headgaar,

Try this in the sheet module:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” or the appropriate sheet” as directed above from the Insert menu

Type "Option Explicit" then paste the code under it

And, you should be ready to go