Create a clear/reset "button"?

I'm just finishing a project that is a collection of three calculators, each of which returns data based on a series of user-supplied variables.

I don't see how the example workbook you provided does any type of calculating.

Although several good suggestion/examples have been put forth, you could get an answer tailored to your specific situation if you provide a workbook that is truly reflective of what you describe above - a collection of calculators.

Thanks all for the replies - I'm very close to the solution. I went with the code suggested by cheeky and shg, though it seems the problem is that one of the fields I'm trying to clear is actually three cells merged and centered. When I run the macro from the worksheet, it returns an error that only reads "400", so I tried running it from the VBA Editor, and it errors: Cannot change part of a merged cell." Is it generally bad practice to use merged cells? I merged them to take advantage of available space in the "UI" and would prefer not to un-merge them... any bright ideas?

I've unmerged the cells, and the script is working perfectly. Thank you all-