Reset and Rename All toggle buttons on Sheet

Hi All,

I have created 50 toggle buttons on a worksheet. The default caption is "Yes / No", but I have created some crude code that sets the caption and colour when pressed / depressed... i.e Pressed = White and Caption "Yes" / Depressed = Grey and Caption "No"

Im looking to create a reset and rename button for them back to depressed / Grey and caption "Yes / No".


Kind Regards

Hi VonBlack

if you want it to work in the current sheet. this will set all toggle buttons to open, switch value to true if desired. Set caption to what you want them to say.
Put this code in the sheet code section

Please Login or Register  to view this content.

if you have multiple sheets and want to reset all put this in a workbook level module.

Please Login or Register  to view this content.

Trigger either from a command button on the sheet or running macro any other way you want.

Absolute brilliant Ron. Cant thank you enough.

you're welcome
took a bit of hunting to find the typename property of the button.