MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to produce a beep when a person enters a wrong entry in a cell


Posted by Kurt on July 27, 2000 7:26 AM

How do you code a vba macro or function maybe using ISERROR to make Excel beep at you when a person incorrectly enters a wrong number in a cell?

Thanks in advance for your help.

Kurt


Posted by Ryan on July 27, 0100 11:10 AM

Kurt,

Use this in your code for a beep:

VBA.Interaction.Beep

Ryan

Posted by Ryan on July 27, 0100 11:12 AM

Use this one

Kurt,

Just put in:

Sub Beep()

Beep

End Sub

The single word Beep will cause a beep.

Ryan

Posted by david on July 31, 0100 11:31 PM

you might also want to put that in a loop to make it a longer beep

for x=1 to 10
beep
next x

3171.html
Take a look at ivans answer to my earlier question