VBA - play audio file click button

[martin_j_king]

Hi,

I have a language xls which has two columns; english word - spanish word
I would like to go through and have a button on each row that when you click it, plays a recorded audio file.
I thought it would be simple but struggling, have tried a few other forums and tried the code but doesn't seem to work

Anybody have any suggestions? Are there any free plugins that assist?

thanks,
Martin

 

[VoG]

This may be a start http://j-walk.com/ss/excel/tips/tip59.htm

 

[martin_j_king]

Thanks for that, the code works great when I want a specific file.

However, I have around 100 files.

What I would like the macro to do is;

in column C, row 2 - 100, there is a list of file names. e.g. test.wav

When the user selects one of these cells, eg Cell C2, text value "test.wav", and clicks the button, it recognises the active / selected cell is c2, reads the test.wav and picks this file from the folder

so assume it is this line of the code that needs to be changed;
WAVFile = "dogbark.wav"

​