|The OP said:|
If cell value become > than 0, I want to replace the formula in cell with the new cell value.
I believe that this line...
bCell.Value = 10
bCell.Value = bCell.Value
This will replace the formula with the value returned by the formula as the OP requested.
To the OP: The code above needs to be manually executed each time you want to replace the 0 values. If you want to have Ax*Bx placed in Column C automatically, you can do it without even using the formula. It all depends on how you want to trigger the code.
For example, if the last entry before the calculation is done is placed in Column B, then this code will place Ax*Bx in Cx as soon as Bx is changed. Since the code is doing the multiplication, you don't need to put any formulas in Column C.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 2 Then
Range("C" & Target.Row) = Range("A" & Target.Row) * Target
There are lots of variations of that code that will place the value in Cx. It all depends on how you are using your spreadsheet.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.