How do I make excel say a phrase when hitting a certain goal in a
Hi,
Right click your sheet tab and view code and paste the code below in. Change
the cell to what you want
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value 30 Then
Application.Speech.Speak "Great Job Hitting AROD Goal"
End If
End Sub
Mike
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"it''''''''sh hardy" wrote:
I'm making a numbers reporting sheet for my retail store, and would like the
sheet to automatically say "Great Job Hitting AROD Goal!!!" when another cell
hits above $30.... Is this possible?
|