Text as audio trigger

Hi all....Im a total VBA newbie and just followed this set of instructions to create an audio alert when a numeric value is triggered. However, I would like to create an audio alert for when certain text appears eg: playsound when A1= BUY etc.....appreciate any help....thanks

I figure i need to adjust this string of code:

Please Login or Register  to view this content.

http://www.excelforum.com/excel-prog...-vba-code.html

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

VBA Noob