On Nov 16, 11:57*pm, magmike wrote:
I am using Excel 2007. I am using four different radio buttons which
all link to cell L29, creating the values 0-4, depending on which is
checked. The default is that none of them are checked.

If I change the value of L29 to 0, then all of the radio buttons will
be unchecked, even if one of them was checked before I changed the
value.

I would like to be able to change the value of L29 to 0, when the
value of a different cell (L18) reads FALSE, so that the radio buttons
are reset. However, if I put the formula in L29, it is overwritten
anytime a radio button change is made. I do not want to use a reset
button - I need the value of L18 in effect to become the reset
trigger.

Any ideas?

Thanks in advance!

magmike

PS - I don't mind using VB, but if there is a way to do in a cell
formula somewhere, that would be preferable to having to save as a
Macro-Enabled excel document.

Thanks,
magmike