Avatar of TIgerV
TIgerV
Flag for United States of America asked on

Run Code on Change

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
Microsoft ExcelVB ScriptProgramming

Avatar of undefined
Last Comment
TIgerV

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
byundt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
TIgerV

ASKER
Thank you VERY MUCH!
Your help has saved me hundreds of hours of internet surfing.
fblack61