Sound File

[Johno]

I am trying to create a test for year seven pupils in IT at a secondary
school in the UK.

I want a sound clip to play automatically when a user enters a new
worksheet, or when an image is pressed. The first is my preference.

For instance once the user clicks continue, the hyperlink will take them to
the next worksheet where the sound file will play:

'This test is 1 hour long and there are 9 sections. It is multiple choice
etc.'

Can anybody give me a dummies (and I mean dummies!) guide to how to do this!

 

[Bernard Liengme]

Look here: http://www.j-walk.com/ss/excel/tips/tip59.htm
And/or Google with: Excel Sound
best wishes

 

[Johno]

Look here: http://www.j-walk.com/ss/excel/tips/tip59.htm
And/or Google with: Excel Sound
best wishes

I noticed this however I don't understand some of it of how to make it play
automatically and how to put the code into the worksheet.

More help would be appreciated.

 

[Pete_UK]

Here's another brief description of how to do it:

http://www.cpearson.com/excel/excelM.htm#PlayWAV

Chip's site also has many tutorials on using VBA - use the Topic
Index.

Hope this helps.

Pete

 

[Johno]

I still can't work it out. How do I add the macro into the worksheet?

 

[Bernard Liengme]

See David McRitchie's site on "getting started" with VBA

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Johno]

I really don't get this. It keeps erroring all the time.

It adds sub etc. and I really don't understand.