LinkBack URL
About LinkBacks
Looking for VBA solution that will refresh/calculate the worksheet, using a start-stop button, I would like to control the refresh rate time.
Looking for VBA solution that will refresh/calculate the worksheet, using a start-stop button, I would like to control the refresh rate time.
Why would you need a button?
If you want to control the refresh rate then Enter a value in cell A1. Use that value with the ontime function to control the refresh rate.
If you really want a button then a simple macro to to force a recalculate is all you need.
Please Login or Register to view this content.
Last edited by mehmetcik; 02-21-2020 at 04:43 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I'm looking for a certain pattern and as the workbook continually refreshes when the pattern shows I can stop the program record the data then restart the code, and adjust the refresh rate faster or slower
Ok
Try this example spreadsheet.
Each time it calculates the Random number changes.
Click on the Calculate Tab to Adjust the frequency of the calculation.
Mehmetcik thanks for the codes, you've given me a lot to work with. Appreciate your work and help, I'll get back with you in a few days to let you know it works for me.
again thanks a lot
Mehmetck, Thanks for the code it's working for my needs, Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks