JNW wrote:

If range("A1").value = "" then
Range("A1").value = 15
else
range("A1").end(xldown).offset(1,0).value = 15
end if

Add another button that clears the selections with code like...
if range("A1").value = "" then
exit sub
else
range(range("A1"),range("A1").end(xldown)).clearco ntents
End if

Do I paste the existing code onto the end of the above.

I have added another option button in the same group. What do I call it for it to
work in order to assign a macro to it?

TIA

--