I have been working on an Excel spreadsheet and wanted to make a beep into some VBA code. Turns out to be very simple as you just put the word beep into the code. For example:
If Range(“A1″) = True Then
Range(“A2″) = True
In this example, if cell A1 is set to True then cell A2 will also be set to true and a beep sound will be made.
If you want to play different types of beep depending on the condition have a look at the following
You can also play WAV files within a VBA macro but that looked a little more complex. Search on “Excel VBA play wav file” and you will find several examples.