I would like to reference this old thread as this is exactly what I am trying to do:
Just reposting what I said in that thread:
Basically, it doesnt seem to work for me. I know the macros work as I tested each of them by creating new objects for each control but the existing ones doesn't get affected for some reason.
The logic I arrived at is maybe because the objects are part of "groups"?
Any assistance is greatly appreciated.
Best Regards,
Reset to all default choices on ActiveX controls
Hi, I have a workbook where I have many ActiveX controls as well as forms controls which will set at certain defaults once the workbook is opened. I would like to set-up a command button named "clear all" that the user could click on to reset all the controls back to their default value. I...
www.mrexcel.com
Just reposting what I said in that thread:
Basically, it doesnt seem to work for me. I know the macros work as I tested each of them by creating new objects for each control but the existing ones doesn't get affected for some reason.
The logic I arrived at is maybe because the objects are part of "groups"?
Any assistance is greatly appreciated.
Best Regards,