Deleting Cell Contents Leave Code

[ryderlane]

Hello All!

I'm using this code to delete contents in a Cell

Private Sub CommandButton2_Click()

Sheets("Calculator").Range("K3").Value = "$0"

End Sub

How do I keep the Formula in Excel from deleting every time I hit the "Clear Button"?

Thank you!

 

[Fluff]

You can't.
What exactly are you trying to do?

 

[ryderlane]

I have X2 Cells that populate once a certain drop down is selected. I wanted to add a button to just delete the contents in one cell, while leaving the formula. Does this make sense?

 

[JLGWhiz]

The only way to remove a value from a cell with a formula that gets the value from precedent cells, is to delete the values of the precedent cells. Any value coerced into the cell with the formula will overwrite the formula, and that includes and empty string value ("").

 

[Michael M]

Change the formula to reflect the need for a zero value, so you don't have to clear it each time.

 

[ryderlane]

https://imgur.com/a/7MYSvfN

Perhaps a picture will help,,,,,,,,,,I'm trying to delete the contents in the "VFP Pricing Field" with a button without clearing the formula. Just for that field.

 

[MARK858]

Perhaps a picture will help,,,,,,,,,,I'm trying to delete the contents in the "VFP Pricing Field" with a button without clearing the formula. Just for that field.

An image I am afraid doesn't alter the fact that you can't clear a cell and keep the formula.

Perhaps if you posted the formula and provide a description of in what circumstances you want the cell to appear blank then someone help amend the formula as per Michael's suggestion.

 

[Michael M]

Dosn't help at all...we know what you want to do.
What is the formula currently in the VFD cell ??

 

[ryderlane]

=IF(G3="5m³",'NutriJet 10 1.5 HP VFD '!E9,IF(G3="10m³",'NutriJet 10 3HP VFD'!E9,IF(G3="1.5HP","$0","$0")))

 

[Michael M]

So you could either

=IF(G3="5m³",'NutriJet 10 1.5 HP VFD '!E9,IF(G3="10m³",'NutriJet 10 3HP VFD'!E9,IF(G3="1.5HP","$0","")))....[color=red] Is blank if nothing is true[/color]

OR

=IF(G3="5m³",'NutriJet 10 1.5 HP VFD '!E9,IF(G3="10m³",'NutriJet 10 3HP VFD'!E9,IF(G3="1.5HP","","")))....[color=red] Is blank if G3 or nothing is true[/color]

OR

=IF(G3="5m³",'NutriJet 10 1.5 HP VFD '!E9,IF(G3="10m³",'NutriJet 10 3HP VFD'!E9,IF(G3="1.5HP","","$0")))....[color=red] Is blank if G3 is true[/color]

A button shouldn't be required at all