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!

 

[ryderlane]

Thank you,

I have 2 Cells (Pump Pricing $) & (VFD Pricing $) that populate pricing once an option is selected in a Drop Down called (System Pump), the 2 options are (5m & 10m) that populate different pricing in each cell. I'd like to add 2 more options in the drop down With a (5m No VFD, 10m No VFD) this would only remove the pricing in the (VFD Pricing $) Cell and keep the pricing in the (Pump Pricing $) Cell.

Can this be done?

Thank you again for the help

"
"