| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ACTIVATING A SOUND ALERT ON CELL VALUE
MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK.
HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
If DDE refreshes A1, then in another cell (say B1) enter:
=A1 This insures that a calculation monitors the value. Finally install the following macro in the worksheet code area: Private Sub Worksheet_Calculate() If Range("B1").Value 100 Then Application.Speech.Speak "The price is right" End If End Sub So if the DDE puts a proper value in A1, B1 will "see" it and the alert will be issued. -- Gary''s Student - gsnu200815 "SOLI" wrote: MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
That is HI-Larious!!! I just tried it and it worked.. Would love more of
those kinds of macros.. "Gary''s Student" wrote: If DDE refreshes A1, then in another cell (say B1) enter: =A1 This insures that a calculation monitors the value. Finally install the following macro in the worksheet code area: Private Sub Worksheet_Calculate() If Range("B1").Value 100 Then Application.Speech.Speak "The price is right" End If End Sub So if the DDE puts a proper value in A1, B1 will "see" it and the alert will be issued. -- Gary''s Student - gsnu200815 "SOLI" wrote: MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
Gary's Student
Beautiful ! It works.Thanks a lot.So simple and short. Maybe you can expand a little more , telling me how to make the speech repeat itself either a few times and/or continuously until I stop it by hitting any key. Also how can I change the value that activates the macro(the 100) to any other number without having to edit the macro.If I could place this new number(the substitute for the number 100) in cell C1 for example, it would be easier. How can I put a second macro for a different cell to be monitored?In the same code? Soli "SOLI" wrote: MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
This version allows you to put the number in cell C1
It also repeats the message 4 times. Private Sub Worksheet_Calculate() If Range("B1").Value Range("C1").Value Then For i = 1 To 4 Application.Speech.Speak "The price is right" Next End If End Sub -- Gary''s Student - gsnu200815 "SOLI" wrote: Gary's Student Beautiful ! It works.Thanks a lot.So simple and short. Maybe you can expand a little more , telling me how to make the speech repeat itself either a few times and/or continuously until I stop it by hitting any key. Also how can I change the value that activates the macro(the 100) to any other number without having to edit the macro.If I could place this new number(the substitute for the number 100) in cell C1 for example, it would be easier. How can I put a second macro for a different cell to be monitored?In the same code? Soli "SOLI" wrote: MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
GREAT! it works well.
may abuse for more? Is it possible to put more than 1 alert in a sheet? Say you want to monitor cell A1 and F1... "Gary''s Student" wrote: This version allows you to put the number in cell C1 It also repeats the message 4 times. Private Sub Worksheet_Calculate() If Range("B1").Value Range("C1").Value Then For i = 1 To 4 Application.Speech.Speak "The price is right" Next End If End Sub -- Gary''s Student - gsnu200815 "SOLI" wrote: Gary's Student Beautiful ! It works.Thanks a lot.So simple and short. Maybe you can expand a little more , telling me how to make the speech repeat itself either a few times and/or continuously until I stop it by hitting any key. Also how can I change the value that activates the macro(the 100) to any other number without having to edit the macro.If I could place this new number(the substitute for the number 100) in cell C1 for example, it would be easier. How can I put a second macro for a different cell to be monitored?In the same code? Soli "SOLI" wrote: MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
Very similar.
I will update this post with a more general solution tomorrow. -- Gary''s Student - gsnu200815 "SOLI" wrote: GREAT! it works well. may abuse for more? Is it possible to put more than 1 alert in a sheet? Say you want to monitor cell A1 and F1... "Gary''s Student" wrote: This version allows you to put the number in cell C1 It also repeats the message 4 times. Private Sub Worksheet_Calculate() If Range("B1").Value Range("C1").Value Then For i = 1 To 4 Application.Speech.Speak "The price is right" Next End If End Sub -- Gary''s Student - gsnu200815 "SOLI" wrote: Gary's Student Beautiful ! It works.Thanks a lot.So simple and short. Maybe you can expand a little more , telling me how to make the speech repeat itself either a few times and/or continuously until I stop it by hitting any key. Also how can I change the value that activates the macro(the 100) to any other number without having to edit the macro.If I could place this new number(the substitute for the number 100) in cell C1 for example, it would be easier. How can I put a second macro for a different cell to be monitored?In the same code? Soli "SOLI" wrote: MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
since you are going to update to a general solution,maybe you could include a
choice of what the alert will speak .It could speak the number contained in the cell B1 instead of a generic unspecified "The price is right".Please maintain the generic alert also. soli "Gary''s Student" wrote: Very similar. I will update this post with a more general solution tomorrow. -- Gary''s Student - gsnu200815 "SOLI" wrote: GREAT! it works well. may abuse for more? Is it possible to put more than 1 alert in a sheet? Say you want to monitor cell A1 and F1... "Gary''s Student" wrote: This version allows you to put the number in cell C1 It also repeats the message 4 times. Private Sub Worksheet_Calculate() If Range("B1").Value Range("C1").Value Then For i = 1 To 4 Application.Speech.Speak "The price is right" Next End If End Sub -- Gary''s Student - gsnu200815 "SOLI" wrote: Gary's Student Beautiful ! It works.Thanks a lot.So simple and short. Maybe you can expand a little more , telling me how to make the speech repeat itself either a few times and/or continuously until I stop it by hitting any key. Also how can I change the value that activates the macro(the 100) to any other number without having to edit the macro.If I could place this new number(the substitute for the number 100) in cell C1 for example, it would be easier. How can I put a second macro for a different cell to be monitored?In the same code? Soli "SOLI" wrote: MY EXCEL BOOK RECEIVES ON-LINE QUOTES FROM A DDE LINK. HOW DO I SET UP AN ALERT TO ACTIVATE A SOUND (OR EXECUTE A PROGRAM ) WHEN THE CONTENT IN A CERTAIN CELL REACHES A PRE-DETERMINED VALUE? I AM NOT TOO FAMILIAR WITH VBA BUT USUALLY I MANAGE TO COPE WITH SIMPLE MACROS.TKS. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
O.K.
-- Gary''s Student - gsnu200815 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
Sorry to barge in again.
Yesterday the DDE link was not available so I tested the macro in a simple Excel sheet. however , to-day I tested it with the real thing and since the imput is continuous(stream) the ^price is right^ every second and it did not stop speaking that. Probably there has to be a brake so we can control how many times the speech (or in new version - the quote )is repeated . Also it is not enough that C1should indicate the value to be monitored, the sign <= also should be able to be substituted within C1 or C2. soli "Gary''s Student" wrote: O.K. -- Gary''s Student - gsnu200815 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
ACTIVATING A SOUND ALERT ON CELL VALUE
Hi "Gary''s Student"
Are you still interested in helping out with the rest of the macros? I' d sure apreciate it much. Solil "Gary''s Student" wrote: O.K. -- Gary''s Student - gsnu200815 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a sound alert in excel spreadsheet | Excel Discussion (Misc queries) | |||
| sound alert from excel | Excel Discussion (Misc queries) | |||
| Sound alert | Excel Discussion (Misc queries) | |||
| Sound+color alert if cell changed in another worksheet | Excel Discussion (Misc queries) | |||
| Sound / Audible Alert in a Woksheet ? | Excel Worksheet Functions | |||
Linear Mode
