Display message based on value using VBA

[BMD4]

Hello,

I have a cell in excel which has drop down of Yes and No.

Based on the value selected, I need to display message using VBA.

I tried the below code but it does not display any message in excel.

Can anyone please suggest what is missing in the code. Thanks in advance.

Please Login or Register  to view this content.

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[NewYears1978]

Try this instead

Please Login or Register  to view this content.

@alansidman - Sorry I posted this before I saw your note at the bottom, if you need to remove this until the OP fixes the codes tags, feel free.

[BMD4]

Thank you.

I tried the same but it doesn't seem to work. Attached the file.

[bebo021999]

Thank you.
I tried the same but it doesn't seem to work. Attached the file.

Hi, try to come back your 1st post, to edit as per requested in #2.
(If not, I will not tell you to make sure you want to trigger any change in cell C2 ONLY)

[NewYears1978]

Thank you.

I tried the same but it doesn't seem to work. Attached the file.

There was no file attached. Also you still need to correct your code in your first post. You need to put code tags around the code you can do that with the # button in the toolbar or you can just type them like [ code ] before the code and [ /code ] after the code, but without the spaces.
My posted code works, but as bebo said, assuming the dropdown is in C2 and that code only checks there Please reupload your sample so we can check it. You did not attach it, you have to pick the file, then click upload, then close that window (it's confusing the first time you use it hehe)

Also, you need to make sure you are putting that code in the sheet code section, not the workbook or module. (right click on the sheet tab and click edit code, make sure the code is in there)

[BMD4]

Hello, I have updated the code format in the first post.

Also, my file is working now. Thank you!

[NewYears1978]

Hello, I have updated the code format in the first post.

Also, my file is working now. Thank you!

Great what fixed it?

[BMD4]

Hello,

The file provided by you worked. I missed syntax when I initially tried it. Thanks again.

[NewYears1978]

Oh, okay great