View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ruben Ruben is offline
external usenet poster
 
Posts: 31
Default Audio warning when cells change

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.
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