reset option buttons

Hi guys

I have a sheet with 5 pairs (Yes or No Choices) of option buttons (from the control toolbox)
What i need is a macro that clears cells eg C3 to C6 and resets the option buttons

But when i try and record a macro that will clear the cells and reset the options buttons back to the NO opiton it will not happen. All i get is the clear cell code

Help

Thanks

Good evening raw

You haven't told us what your option buttons are called, so again I will have to generalise a bit with my answer. The code / syntax you want is:

OptionButton1.Value = True

but obviously, you may have to change the option button names, true / false etc depending on your sheet set up.

HTH

DominicB