Okay I figured it out finally. I'm going to explain here in case someone have similar requests in the future:
You have to use the Worksheet_Calculate() function if you want to run any macros automatically on cells updated by formulas or by streaming data. Worksheet_Change or anything else will NOT work, at least from my experience.
Anyways I'll just post my entire code below. This code will make you able to run macros based on cell updates from formulas or streaming data, guaranteed:
Then you need to make a new module, name it "module1" or whatever. Enter this text
And you're good to go.
Bookmarks