Darren_workforce
Board Regular
- Joined
- Oct 13, 2022
- Messages
- 136
- Office Version
- 365
- Platform
- Windows
Hello,
I have a very basic training simulator setup in Excel which is designed to replicate a window of an external application. I have VBA code setup so that when someone is done practicing, they can click on a button and it clears all cells that have user-entered data. Very basic: Range("C7:G8").ClearContents, but my issue is that aside from the user entry fields, I have a number of data validation lists that are setup so the trainee can just click and select from the dropdown menus. It is setup so that the default values are displayed based on the actual production application. For the purposes of the simulator, the "default" values are just setup as the first item within each data validation list.
Can something be setup within VBA similar to ClearContents but instead of it clearing the data validation lists entirely, instead it would revert each of the data validation fields back to whatever their default value was within the lists?
Thank you for any and all assistance!!
I have a very basic training simulator setup in Excel which is designed to replicate a window of an external application. I have VBA code setup so that when someone is done practicing, they can click on a button and it clears all cells that have user-entered data. Very basic: Range("C7:G8").ClearContents, but my issue is that aside from the user entry fields, I have a number of data validation lists that are setup so the trainee can just click and select from the dropdown menus. It is setup so that the default values are displayed based on the actual production application. For the purposes of the simulator, the "default" values are just setup as the first item within each data validation list.
Can something be setup within VBA similar to ClearContents but instead of it clearing the data validation lists entirely, instead it would revert each of the data validation fields back to whatever their default value was within the lists?
Thank you for any and all assistance!!
Last edited: