Dears,

I hope each and every one of you is having a good day

So what I'm trying to do is: There is a webpage that has some numbers that are continuously changing, I want a cell of my excel sheet to get live updates of one of the numbers on the webpage.

What I have so far: I wrote a VBA code (First time VBA, kind of expert in Java), that gets the number and sets it inside the active cell without any problem. But, what I want it to do is keep getting live updates of the number on the webpage.

What I tried to get live updates: I tried to use an infinite loop but it makes my Excel window unresponsive. I also tried Application.OnTime but I failed to find-out how to pass a parameter to it

Here's my excel file, you can see the VBA code: Book1.xlsm

Any help is appreciated
Best regards