Play Sound When Conditions are Met

[Chris632]

Hello,

I have a spreadsheet that I'm using to scan barcodes using a handheld scanner. I have a vlookup formula that checks that the scanned barcode is on the first sheet, and then enters the value of that barcode if so. What I am looking for is if a barcode is scanned that does not exist on the first sheet, to immediately play a sound to alert the operator that the scanned barcode is invalid.

The scanning takes place on the 'Scan Sheet' in ColumnA, starting at A8. Columns B & C contain vlookups to return data related to the barcode. My thought is if A8 receives input but B8 and C8 still display "#N/A", then play sound.

Attached is a sample file, hope this makes sense. Appreciate any assistance!

Chris

[mrice]

Try this pasted into the Sheet3 page in the VBA editor (Alt F11). Remember to save in .xlsm format.

Please Login or Register  to view this content.

[Chris632]

Hi Martin, that seems to do the trick. Thanks!