Beep sound when condition met.

[Rufles]

Hi all,

The macro below is adding the SUM cell. Is it possible to make a beep sound when SUM cell value will be the same as one on the left?

Please Login or Register  to view this content.

[Richard Buttrey]

Have you tried

Please Login or Register  to view this content.

[Rufles]

The problem is I have 10s of sum cells in column L and some of them already match. I need a beep only for the ones just matched the value.

[Richard Buttrey]

Hi,

I don't understand your concern. The code is only testing the single target cell. I'm assuming of course that your codes is in the Sheet Change event. You didn't show the procedure name.

[Rufles]

Sample file for review as attached

[Richard Buttrey]

Hi,

Put this as the first three lines in your procedure

Please Login or Register  to view this content.

It will beep whenever you enter a value in column L that has the same value as column K on the same row.

[Rufles]

I did it and no beep...

Please Login or Register  to view this content.

[Rufles]

If I put the value manual then I have a beep.
But when the SUM will get the value it self the its quiet.

[Richard Buttrey]

Hi,

I hope we're not going round in circles.

That's what the first code I gave you does. Put it immediately after the Application.EnableEVents = True

When you subsequently said it didn't work I assumed you'd tried the original but wanted it to work when you manually enter the data.