Play sound when condition is met

[Rufles]

Hi all,

I've a macro below witch is adding the SUM cell and I'm wandering if I can add somthing here to play a sound when result from "L" match the cell -1 like "K".

Please Login or Register  to view this content.

[hemesh]

you could use another if with offset and in the true part of if use below

Application.speech.speak("Both are Equal") if you want to play "both are equal" keyword or can use Range(type range or set with variable).value

[Rufles]

It sounds good but I don't know how to put that in to my code witch I was helped to create. And also I've a file with sound I want to use it.
Any help, please?

[hemesh]

please upload your file

[Rufles]

Here yo go