Play music when i click a button in excel

[oldmanwilly]

HI

I want to play music while a form is open, and when someone clicks on a text box in the form for a sound effect to play like a bell chime or something, and when they click another button on the form another sound effect.

Is there a simple line of code that can do this?

THanks

 

[oldmanwilly]

Re: How to play music when i click a button in excel

You function declaration is wrong ...

[COLOR=#ff0000]public[/COLOR] declare function sndplaysound32 _Lib "[COLOR=#ff0000]2[/COLOR]winmm.dll" _
Alias "Sndplaysound[COLOR=#ff0000]a[/COLOR]" ( _
Byval [COLOR=#ff0000]1[/COLOR]pszsoundname as String, _
byval uflags as Long)as long

Should be :

Private Declare Function sndPlaySound32 _    Lib "winmm.dll" _
    Alias "sndPlaySoundA" ( _
        ByVal lpszSoundName As String, _
        ByVal uFlags As Long) As Long

i still get red writing if i copy and paste your code, into a module or intot he thisworkbook section?