cell values
 

How do I set up a formula that will write a zero to a range of cells?
I wish to click on a radio button or such to effect this action.

Hi

Formulas can't do this.

You can insert a button from the forms toolbar and assign a macro to it

Sub test()
Sheets("Sheet1").Range("A1:A10").Value = 0
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message oups.com...
How do I set up a formula that will write a zero to a range of cells?
I wish to click on a radio button or such to effect this action.

If you know in advance which cells you want to put zeroes into, you could
select them all, name the range, then record a macro that does Edit--Go
to--enter the named range and hit Enter. Type a 0 and hit Ctrl+Enter, then
stop recording the macro. Put the macro on a toolbar button. References:
http://www.officearticles.com/excel/...soft_excel.htm
http://www.officearticles.com/misc/m...ica tions.htm
************
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...
How do I set up a formula that will write a zero to a range of cells?
I wish to click on a radio button or such to effect this action.