Adding a sound to Conditional formatting?? Can it be done?

Hi,

I'm not the brightest excel wizard and have had much help from firends and forum members in getting my preadsheet to a certain point.


Basically I have a two sheet project



Sheet 2 (titled "Data") is a dump of a barcode number and a status for it.

Sheet 1, (titled "Scan Sheet") a user scans the barcode and it displays the relevant status (sources from sheet 2) and also applie conditional formatting for colors of the status....



What im wanting to do is a play a .wav sound for one of the status' each time it comes up... is this even possible?


i can email a copy of the project if someone thinks they can help.....

Yes, I believe it is possible, can you attach your worksheet excel file using the attchment paperclip?

Originally Posted by redsab

Yes, I believe it is possible, can you attach your worksheet excel file using the attchment paperclip?

hello,
now attached... also i hope im not being too greedy, but ive since read up that it may also be possible to add a pop up box as well

test scanning.xlsm

hello again...

i have since found this website which ALMOST solves my problem.... http://www.pcreview.co.uk/forums/can...-t2520693.html

HOWEVER, i have played with the VBE and cant get it to perform on more than one cell (cant change the range)???

i have it sent for cell M7 to check cell b7 but it wont allow me to apply to cell m8, m9 ect ect in the vbe

test scanning 2.xlsm