Pop-up / Alarm notification

I have a file with a dropdown list with ADD, CHANGE & DELETE. I want to add some sort of anouncement if the user chooses CHANGE. A written pop up message. I don't want to use an 'input message' when the cell is chosen. I only want the notice when a specific option is chosen.

In the Sheet module:

Please Login or Register  to view this content.

If you want to play sound check out: http://support.microsoft.com/kb/158140

The code needs to go in the appropriate Sheet module, and you need to change "A1" to the correct cell reference.

Adding Code to a Sheet module
1. Copy the code from the post
2. Right-click on the tab for the relevant sheet and select View Code. This opens the Visual Basic Editor (VBE) and shows the object module for the selected worksheet.
3. Paste the code in the window
4. Close the VBE to return to Excel