troubleshooting Question

Run Code on Change

Avatar of TIgerV
TIgerVFlag for United States of America asked on
ProgrammingMicrosoft ExcelVB Script
2 Comments1 Solution336 ViewsLast Modified:
I have code that updates an electronic Sign every time I push the "SEND" button in Excel.

However, Can I force excel to monitor the cells (only 12 of them) for changes and run the code automatically?

So, If I change cell B3, Excel runs the code I have in the "SEND" button.

Also, I have a cell that is a countdown timer.  Once the timer is started, and as long as the value is greater than "0:00:00", I want to run the code every 10 seconds.

Seems like If I just run the code every 10 seconds, it would do the same thing, I'm not trying to be precise, just a general countdown of values from 10 minutes to 0:00:00
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros