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


    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.

    Kieran

Participate now!

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