Sounds in 2002

William B · Oct 30th 2005

I would like to have the user press a button and hear a "click" or perhaps other sounds.

SoundNote has apparently been removed from Excel 2002. Not that I would have known how to use it anyway ...

Does anyone know of a way to have a button "click"?

Kieran · Oct 30th 2005

Re: Sounds in 2002

Try this

Private Sub CommandButton1_Click()
Beep
End Sub

William B · Oct 31st 2005

Re: Sounds in 2002

Thanks it seems awfully complicated ... LOL

Kieran · Oct 31st 2005

Re: Sounds in 2002

Oops,

I should have been a bit more explicit.

For any button 'CommandButton 1' the following code will cause a beep.

Code

Private Sub CommandButton1_Click()
Beep
End Sub

Basically the single VBA line of

Beep

does the work, you can include it anywhere in your code for it to work.

Participate now!