vba .ontime

[jaden210]

hey, I am Familiar with the .ontime function to recalculate a macro every x minutes, but is there a similar function that will work to recalculate a function instead of a macro? I have a function that pulls info from a website, but the website is always changing and i'd like it to check for new info every 30 seconds or so.. I can attach the function if that will be any help. Thanks!

 

[dspel79082]

Hi, Jaden. I would think that you could just use the macro recorder to record the process of refreshing the data, then attach the ontime method to that macro.