PDA

View Full Version : [SOLVED] VBA for playing sound effect!



clif
07-13-2010, 08:14 AM
I want the vba for playing the sound effect. If A1 = B1 , then it will play the sound automatically! Can anyone help? Thanks! :hi:

GTO
07-13-2010, 08:34 AM
See if this helps:

http://www.vbaexpress.com/forum/showthread.php?t=24370&highlight=playsound

clif
07-25-2010, 07:13 AM
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!

Simon Lloyd
07-25-2010, 07:48 AM
Perhaps check this out http://www.cpearson.com/excel/PlaySound.aspx

clif
07-25-2010, 08:36 AM
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!

Simon Lloyd
07-25-2010, 08:55 AM
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.