ClearContents in relation to data validation lists

[Darren_workforce]

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!!

 

[Darren_workforce]

I should add that the data validation lists are located in a hidden worksheet within the same workbook. If that matters. Using the macro recorder, within a test cell, I developed

Range("V12").Select
    ActiveCell.FormulaR1C1 = "=Sheet2!R[-2]C[-20]"

I just basically asked VBA to replicate whatever was in the Sheet2!R[-2]C[-20] to display in V12. It appears to have done what I needed and while I think I technically worked it out, if there's a simpler formula to update all 5 data validation fields quickly, I'm open to professional opinion.