Michael Hulse
asked on
Excel VBA
I have an excel spreadsheet which I have put =RandomizeF in various cells to generate random alpha numeric data in. I want to add a button on the spreadsheet that when clicked would simply cause specified cells to refresh/reload the data in them.
You can easily create a macro or VBA that runs when the button is clicked. The Macro or VBA code you create would either need to call the function where you initially set the random values or you would need to build a function that writes random values to the cells you want.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just use Shift + F9 (calculate open sheet) or F9 (calculate all worksheets).
»bp
»bp
Pleased to help