Hi all, is it possible to create a simple worksheet refresh button? I have a few rand and randbetween functions and instead of entering a cell and pressing enter, I just wanted to hit a refresh button. Is there a simple remedy for this please?
Hi all, is it possible to create a simple worksheet refresh button? I have a few rand and randbetween functions and instead of entering a cell and pressing enter, I just wanted to hit a refresh button. Is there a simple remedy for this please?
You could assign the below macro to a button:
Please Login or Register to view this content.
worksheets("SheetOfRands").calculate
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Or just press F9
多么想要告诉你 我好喜欢你
Formula tab -> Calculation->Calculate Now
why create button, when already there is standard one on RibbonX?
If you are pleased with a member's answer then use the Star icon to rate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks