Question about Microsoft Office Professional 2007 Full Version for PC
AFTER CALCULATING USING EXCEL FORMULA,
CAN I GET A SOUND ALLERTING ME IF THE VALUE
IS MORE THAN A CETAIN NUMBER,SAY 100 ?
No there is not any settigns that allert of sound on condition base.
Posted on May 30, 2009
Here's the formula:
if range("A1").value > 100 then
BEEP
end if
and you might want to loop the BEEP so that it's louder/longer :
for x = 1 to 10
BEEP
next x
HERE'S ANOTHER ONE:
you can stick this code inside a Worksheet_Change event :
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value > 100 Then
For x = 1 To 10
Beep
Next x
End If
End Sub
Good luck!
Posted on May 30, 2009
Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Good luck!
Posted on Jan 02, 2017
Apr 08, 2017 | Excel Computers & Internet
Apr 02, 2008 | Computers & Internet
Jan 19, 2016 | Computers & Internet
Dec 13, 2013 | Microsoft Excel for PC
Sep 30, 2011 | Microsoft Excel 2010
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
Nov 05, 2009 | Microsoft Office Excel 2003 for PC
Sep 30, 2009 | Microsoft Excel for PC
Apr 18, 2009 | Microsoft Office Excel 2003 for PC
Jun 10, 2008 | Microsoft Excel for PC
72 people viewed this question
Usually answered in minutes!
Thanks for quick response.
I have tried every which way to write the formula ,without success.
Perhaps you would be good enough to rewrite the formula so that I can copy
and paste.
Thanks.
Azmanz
×