Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default I need the code for Audio Warning!

I have a spreadsheet that gets its values from a query. When those values
change below a certain number then I would like to hear an audio warning. How
can this be done? Anyone responding please tell me exactly where to paste the
code since I'm not a programmer.
Thank you!!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 64
Default I need the code for Audio Warning!

You need to be specific as to data, cells, sheets, etc... While
handholding is what this forum is for, magic and mindreading is on
another forum altogether...

On Aug 15, 3:52 pm, Ruben wrote:
I have a spreadsheet that gets its values from a query. When those values
change below a certain number then I would like to hear an audio warning. How
can this be done? Anyone responding please tell me exactly where to paste the
code since I'm not a programmer.
Thank you!!



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default I need the code for Audio Warning!

OK, The data is on a sheet called "runs", the cells in question are "K4:K9",
the cells contain numbers "K4=20,K5=88,K6=22,K7=22,K8=75,K9=44". These values
come from a query called "Monitor". Whenever these cells change in value,
whether they go up or down, I would like an audio warning.
thank you
"KLZA" wrote:

You need to be specific as to data, cells, sheets, etc... While
handholding is what this forum is for, magic and mindreading is on
another forum altogether...

On Aug 15, 3:52 pm, Ruben wrote:
I have a spreadsheet that gets its values from a query. When those values
change below a certain number then I would like to hear an audio warning. How
can this be done? Anyone responding please tell me exactly where to paste the
code since I'm not a programmer.
Thank you!!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Audio warning when cells change Ruben Excel Discussion (Misc queries) 1 August 17th 07 08:30 PM
What is the VBA code to delete a sheet without warning message? [email protected] Excel Discussion (Misc queries) 2 August 9th 05 04:16 PM
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel Fredrik Wahlgren Excel Programming 0 April 14th 05 10:53 AM
Code & modules are gone, Macro warning message remains David McRitchie Excel Programming 1 September 10th 04 11:17 PM
getting a macro warning, even through there is no code Sandy[_5_] Excel Programming 4 November 15th 03 03:15 PM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"