I have sheet that queries warehouse stock on internet using a VBA function to display current stock levels of a few key items.
I can use Ctrl+Alt+F9 to refresh and that does the job successfully.
Question is... how can I refresh sheet automatically every 60 seconds? (Range B1:B3)
Col A Col B
AB-121 =Wstock(A1)
AB-230 =Wstock(A2)
CA-460 =Wstock(A3)
I'm using Excel2007.
Any help is appreciated.
Lee
Last edited by LeeB9622; 08-06-2020 at 02:14 PM. Reason: update
Hello LeeB9622,
This is something that I have came up with. You can tweak it to work for your needs.
The macro below goes through a loop and refreshes a sheet on the workbook at set intervals. Currently, it is set to refresh 6 times every 3 seconds on the active sheet. All of this can be changed to your liking.
There might be a more elegant way of doing this, but this is the method I have used before.
Please Login or Register to view this content.
Best regards,
~Frab
Maybe you can try like this:
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Tried the following :
Works when cells contain =RAND() but not with =WSTOCK(A1)Please Login or Register to view this content.
Does work however with Ctrl+Alt+F9
Why does it not recalc with my Calculate_Range Sub?
Add into your WSTOCK function as 1st line:
then should works with your Calculate_Range sub.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks