Sounds in 2002

  • 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"?

  • Re: Sounds in 2002


    I should have been a bit more explicit.

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

    Private Sub CommandButton1_Click()
    End Sub

    Basically the single VBA line of


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


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!