Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Audio warning when cells change | Excel Discussion (Misc queries) | |||
What is the VBA code to delete a sheet without warning message? | Excel Discussion (Misc queries) | |||
How to get rid of the warning msg from Outlook when sending email via VBA code in Excel | Excel Programming | |||
Code & modules are gone, Macro warning message remains | Excel Programming | |||
getting a macro warning, even through there is no code | Excel Programming |