I am a complete VBA novice and I'm trying to find a way to generate random numbers with a button click.
Here are the parameters I'm looking for.
There are multiple cells I want effected with the click of one button.
I want the button to generate random numbers between 4 and 24 (and possibly subtract 4 from the final result with a minimum outcome of 1)
I want the button to be disabled after one click, but I want a reset button to set the generated numbers back to 0 and re-enable the random button.
Help appreciated!
Bookmarks