| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search folder/directory for a phrase inside excel files | Excel Discussion (Misc queries) | |||
| i'm looking for VB code that does the same as hitting F2 in excel | Excel Programming | |||
| Excel-hitting tab moves me more than one column over | Excel Discussion (Misc queries) | |||
| Alpha Phrase To Phone Number Calculator in excel | Excel Discussion (Misc queries) | |||
| Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
Linear Mode
