• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sound alert only when cell changes

B

BYK

New Member
Can anyone help me with this one.

I am trying to have a sound alert whenever my cell B2 changes its value.
However, the values can be one of three words, and can change constantly throughout the day.
I just need a sound alert "once" every time it changes. I saw some code to make sounds when value = "some word" but then it would keep making the sound till that "some word" would change.
I just need an alert every time the cell has a change, and not sound until the next change.
Would really appreciate your help.
 

Hi !

So when you modify B2 cell value, you want a sound
warning you just changed value ?‼
​
 
Hey Marc!
B2 is a formula that produces either "h", "m", "l"
that cell changes based on all these other conditions and cells doing all this work; I don't manually modify it.
B2 doesn't change that often, but when it does, I want to have a sound alert letting me know that B2 just changed value. I don't need a sound to constantly loop, but only the moment B2 changes from result to result.
 

So from a formula the Change worksheet event does not work !

So instead of B2 cell, maybe if you trap the source data from formula …
​
 
ahhhh, no wonder no matter what method I use, it does not recognize just a change, unless I specify what the change is.
how do you trap the source data?
 
You must log in or register to reply here.
Back
Top