Need sound for both 32 and 64 bit Excel

[CriticalMass048]

Last month, I had posted a request that would allow me to add simple sound effects to my spreadsheet. TMS was nice enough to help me, but it seems that the spreadsheet causes a major error on my home computer (64 bit version)

My original post is here:
https://www.excelforum.com/excel-gen...ml#post5620681

I have done enough research on my own to determine that the problem is with the 64 bit version, but I am too much of a novice to understand how to adapt TMS's code to allow the spreadsheet to function on both versions.

I hope someone can help! Thanks!

[romperstomper]

The function declaration was wrong - it should be:

Please Login or Register  to view this content.

not:

Please Login or Register  to view this content.

[CriticalMass048]

Thank you! I will give it a shot!

[CriticalMass048]

When I copied the same code as before but replaced the declare statement with your top line, I get "Compile Error" and "Expected: end of statement".

Did I do something wrong?

[romperstomper]

Sorry, I overlooked the type declaration character on the function name. Either use:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

The blue bits are effectively equivalent.