cell values

[don.wick]

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.

 

[Ron de Bruin]

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

 

[Anne Troy]

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/record_a_macro_in_microsoft_excel.htm
http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_office_applications.htm
************
Anne Troy
www.OfficeArticles.com