Perpetual VBA Macro for Excel

Hi,

I’d like to have a macro perform real-time operations to an excel file while it is open. It would be similar to a forever loop running on a separate thread. It would perform operations upon data updates or at certain times. Is something like this possible?

Thanks,
Allen