How do I make excel say a phrase when hitting a certain goal in a
in [Programming]
|
From: it''''''''sh hardy on 7 Feb 2010 16:43 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?
From: Mike H on 7 Feb 2010 16:55 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?
From: Mike H on 7 Feb 2010 16:57 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?
|
Pages: 1 Prev: Method to group lines Next: Call macro after "macros are enabled" |