Create a clear/reset "button"?

Does anyone have a way to clear the contents of another cell [actually several] cells via another cell?

What is the condition/value in "another cell" that should trigger a reset of the input cells?
What are the sheet/range references for the input cells to be cleared?

Upload a sample workbook if you can.

The condition/value of the "clear variables" cell is what I could use some suggestions on. I don't suppose it would be possible to create a cell that needs only be clicked [hyperlink?] to clear the other cells.

As far as the cells that need to be cleared, I have two types of Data Validation, which I have recreated in the attached example. The first is a simple drop-down list [Animals], and the second [Decimal] allows a decimal to be entered, but ONLY if an animal has not been selected.

Right-click the sheet tab
Select View Code
In the window that comes up paste this:

Please Login or Register  to view this content.

Substitute B2 etc. for your ranges. You can add more, I'm sure you'll be able to piece it together.
Close that window (the whole VBA editor)
Right-click a toolbar (to get a list of available toolbars)
Get the "Forms" toolbar
Click the button icon
Draw a button on your sheet, it should ask you for a macro, pick ClearCells
profit

HTH

see the example.
use some variation of code given by Cheeky Charlie.
modytrane

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-

It is uniformly terrible practice to use merged cells

:D

I agree 100%, though I've never managed quite the pithy flourish of this remark in any of my anti-merged-cells rants

If your merged cells were on the same row, you can use "centre across selection" alignment to achieve a merged-and-centred effect (select cells, Ctrl+1, CAS is the last horizontal alignment setting in the list)

CC