Code for Range Monitoring / Trigger Shell Command

[schelber]

could someone point me in the right direction for how VBA would look if:

on worksheet Buffer Status:

I have temperature ranges in Rows 7-20, Column G and their minimum threshold in column H and their maximum threshold in column I:

such that if the value in G is > corresponding threshold in I and < than corresponding threshold in H then execute shell command

Shell "C:\Program Files\Skype\Phone\Skype.exe" /callto:+12156522325 AND

run macro 'SendEMail'.........so that a list of mailers will be notified

I already have the SendEMail code working OK and I want to paste this code right into the worksheet called Buffer Status.

Just not sure how it would look.

Thanks for any help on this.......I have not been able to find many examples of shell commands triggered by cell values.

Rich

 

[Norie]

Rich

Do you want to trigger code when cell values change?

 

[schelber]

exactly.........i have a spread that has those temp values updated every hour via server over a VPN and should any breach the assigned thershold I want to execute the

SendEMail macro and trigger a macro to execute a shell command below:

"C:\Program Files\Skype\Phone\Skype.exe" /callto:+12156522375

Thanks , Rich