Inserting a function into VBA code

I have a spreadsheet that I'm trying to get sound output form when a certain value comes up in a cell. I have all the code for the sound output and it works fine when I type in that value, but when the value is created from my excel formula, the sound code doesn't work. I am assuming I need to put my formula into my VBA code, but I's not quite sure how to do it. My formula in the sheet is a nested If/Then statement. How do I write that in VBA code within my module and would I put it before or after the code for the sound output?

Here is my formula as it appears in the workbook: =IF(B1=C1,"MATCH", IF(B1="",(""),"NO MATCH"))

My exisitng code is:

Please Login or Register  to view this content.

Sorry, another rule to be aware of:

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

With the "MATCH" "NO MATCH" problem,

Now my code reads as this :

Please Login or Register  to view this content.