Reset Button

**va33eric** · 07-16-2008, 09:35 PM

I'm trying to create a reset button to clear some cells in a form but leave the formulas. I created the button and it clears the text but also the formula in the cell...these are not combo boxes btw...just cells. Thank You...Eric

**va33eric** · 07-16-2008, 09:58 PM

I'm trying to create a reset button to clear some cells in a form but leave the formulas. I created the button and it clears the text but also the formula in the cell...these are not combo boxes btw...just cells. Thank You...Eric

**Trebor76** · 07-16-2008, 10:08 PM

Hi Eric,

Not sure how you're setting the range and/or clearing the cells within it, but you need to include an IF statement in your code incorporating the VBA "HasFormula" property.

HTH

Robert

**shg** · 07-16-2008, 10:41 PM

You can't do that with worksheet functions (the forum you're in). It would require VBA.

You could select all the input data cells, go to the Names box (left of the formula bar), and apply a name (like Input). Then when you want to clear, go the the Names box, type Input, and then hit Delete.

Or unlock the data entry cells, and then protect the worksheet disallowing selection of locked cells. Then to clear, do Ctrl+A (Select All), and hit Delete.