Hello! I have so far found immense help from the users of this forum, as well as their threads. Hopefully, you can bear with my questions once more.

I use an RTD function to receive both the Last Trade Time and the Last Price of stock data. Last Trade Time is updated every minute and its format is mm/dd/yyyy hh:mm:ss. I need to use VBA to read the date (i.e. the minute changing) and then count in another cell how many times the Last Trade Time has been updated.

Furthermore, are there obstacles using VBA macros and the RTD function simultaneously?

Thank you!

Aki