I want the vba for playing the sound effect. If A1 = B1 , then it will play the sound automatically! Can anyone help? Thanks!
I want the vba for playing the sound effect. If A1 = B1 , then it will play the sound automatically! Can anyone help? Thanks!
See if this helps:
http://www.vbaexpress.com/forum/show...ight=playsound
I have attached the excel file. If the cell in column C is greater than the cell next to it in column B, then play the sound effect once. What is the script. Thanks!
Perhaps check this out http://www.cpearson.com/excel/PlaySound.aspx
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
I am a beginner. I don't know how to set the vba for cells also? Can anyone help me to admend the excel file or provide the scripts? Thanks a lot!
The Chip Pearson link i gave you gives you all the "script" you need and is well explained!
Try putting something together and attaching that then we can help get you where you want to be.
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)