How do I make excel say a phrase when hitting a certain goal in a
 

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?

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?

How do I make excel say a phrase when hitting a certain goal in a
 

I forgot to mention that speech must be enabled in the windows control panel
--
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?

How do I make excel say a phrase when hitting a certain goal i
 

Ok thanks!!! But maybe I should have clarified - I dont want it to literally
say that, I want it to appear in another cell in Red...

"Mike H" wrote:

I forgot to mention that speech must be enabled in the windows control panel
--
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?

How do I make excel say a phrase when hitting a certain goal i
 

Hmmmm,

Yes you could have made that clearer!!

=IF(A130,"Great Job Hitting AROD!!!","")
--
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:

Ok thanks!!! But maybe I should have clarified - I dont want it to literally
say that, I want it to appear in another cell in Red...

"Mike H" wrote:

I forgot to mention that speech must be enabled in the windows control panel
--
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?

How do I make excel say a phrase when hitting a certain goal i
 

LOL Thanks Mike - sorry about that!


"Mike H" wrote:

Hmmmm,

Yes you could have made that clearer!!

=IF(A130,"Great Job Hitting AROD!!!","")
--
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:

Ok thanks!!! But maybe I should have clarified - I dont want it to literally
say that, I want it to appear in another cell in Red...

"Mike H" wrote:

I forgot to mention that speech must be enabled in the windows control panel
--
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?

How do I make excel say a phrase when hitting a certain goal i
 

Glad I could help
--
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:

LOL Thanks Mike - sorry about that!


"Mike H" wrote:

Hmmmm,

Yes you could have made that clearer!!

=IF(A130,"Great Job Hitting AROD!!!","")
--
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:

Ok thanks!!! But maybe I should have clarified - I dont want it to literally
say that, I want it to appear in another cell in Red...

"Mike H" wrote:

I forgot to mention that speech must be enabled in the windows control panel
--
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?