Creating a beep sound in Excel – did you know you could make the sound appear on ‘command’? Watch the video to learn more

Creating a beep sound in Excel: Excel iconThis week’s hint and tip is on creating a beep sound in Excel. Recently John was at a customers site carrying out some development in Excel and a question came up about the beep sound. This isn’t covered in any of our courses so we decided to do a hint and tip on it. We are going to go through it now below.

 

The beep sound

This sound is often one that many have heard when working in Excel. When you make a mistake in typing out a function or when you’ve typed a number out of range in to a cell with number data validation applied to it. When either of these have occurred a beep sound has appeared to let you know that something is not right.

Did you know you can make an error activate a beep to signify that the error has occurred? In a recent visit to a customers site this question was asked and so John went away to investigate.

 

Making the beep sound appear

This is able to be done through the use of macros and VBA coding. List data validation, conditional formatting with colour for errors and IF statements were being used in the customers spreadsheet mentioned above. Leading on from this a macro was inserted into the IF statement. This macro caused a beep sound to occur when a specific word was selected from the drop down list.

 

The video below shows you how you can insert the macro into an IF statement to make a sound occur when a word is selected from a list. This demonstrates how simple it is and it may spark off ideas on how to do this on your own worksheets.

Take a look below at the video to find out more and then try them out on your own computer!

We hope you have enjoyed this hint and tip on creating a beep sound in Excel. Why not take a look at our previous video hint and tip on part 3 of our Word Useful Features?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy