Blue Cheeseburger
New Member
- Joined
- Feb 23, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet where the user clicks a button, and a random number is generated and displayed. If the new random number is the same as the previous number, it's hard to be sure that anything happened. I tried writing code so that when the user clicks the button, the previous number is cleared, and a MsgBox is displayed. When the user clicks the MsgBox, the new number is displayed. Is there a way to do something like this automatically, without requiring the user to click on a MsgBox? Thanks.