Play sound in Excel

[buffalobill]

I hope someone can help, I want to have excel play a sound if a cell is >= A, how would I go about it. I am very much a begginer at excel and do not know to much about VBA, can this be done without using the VBA?
Thanks in advance for any help.

[DonkeyOte]

for basic info in terms of playing sounds in XL see: http://www.exceltip.com/st/Playing_W...Excel/460.html

by the sounds of it you will be looking to apply the above to a Worksheet_Change event for a given cell.

[buffalobill]

Thanks that sounds like exactly what I want to do, having a bit of difficulty though, Im not all that clever when it comes to VBA, do I just paste that macro into the VBA, if so how does it know which cell I want to monitor the change for it to play the sound...sorry for the excel 101 questions, one day Ill understand it a bit better at present it just makes me dizzy everytime I look at VBA.
Thanks again for your help

[DonkeyOte]

In essence you would do the following...

On the sheet against which the change event is to fire - right click the tab name, select View Code and paste below into resulting window:

Please Login or Register  to view this content.

Then whilst still in VBEditor go to Insert -> Module ... in the resulting window enter:

Please Login or Register  to view this content.

Now go back to XL and save your file. Thereafter assuming Macros are enabled whenever A1 is altered on the sheet you chose and the value is such that it ">A" then you should hear the sound... assumes sound card installed etc...

NOTE: the file name of the sound is for you to set... it should be to a valid file and if you intend to roll out to other users you must ensure all will have access to it
(ie if local destination you need to be sure you're all running the same OS etc...else location of windows sounds *may* vary client to client ... my lack of knowledge re: OS is sufficient that the above may not be a concern)

[buffalobill]

Thank you very much, Ill give this a shot and let you know how it turns out, appreciate all the help.