Typing in a number on a cell that already has an active cell function without earasing fun

[jjin]

Hi guys,

Please open the sample excel file attached below first so you have better understanding of my question.

Cheers,

[HaHoBe]

Hi, jjin,

maybe use the Worksheet_Change-Event behind Sheet1 for this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A5:B5")) Is Nothing Then
  Range("D5").Value = IIf(Range("A5").Value - Range("B5").Value > 0, "Yes", "No")
End If
End Sub

I didn´t put in the formula but only the result as you mentioned that the formula may get lost to overwriting.

..without erasing function

AFAIK no chance without a helper cell for direct entries.

Ciao,
Holger

[jjin]

Hi HaHobe,

Thank you for the quick reply. That's exactly what I am after but then I will have to change the existing code that I already have on the cell in order to apply the new code you suggested above isn't it? The code thats currently running on the cell is quite long and I have no clue how to combine it with your new code. :P

Any other suggestion without altering my existing code on the worksheet?

Cheers,

[HaHoBe]

Hi, jjin,

maybe you should not only mention that you have VBA-Code but show the code - maybe it can be amended to suit?

Ciao,
Holger