Subtracting from a cell

[MhmdHalawi]

Hi all, I'm kinda new to Excel Vba, and I'm making a very small project, so the thing is , I have a column (C) that has a header and a bunch of values under it, and what I need is that each time I enter a value in that column it will be subtracted from a specific cell (F1), it should be done automatically after entering the value for example in C2 then F1 would be F1-C2 and if I enter a value in C3, then it would be subtracted from F1 again. So, F1-C2, F1-C3, F1-C4,... and so on.

 

[JustynaMK]

Hi,

Go to VBA > double-click on Sheet1 > add this Event:

Private Sub Worksheet_Change(ByVal Target As Range)
    
    Application.EnableEvents = False
    
    With Sheet1
        If Target.Column = 3 Then
            Target.Value = Target.Value - .Range("F1").Value
        End If
    End With
    
    Application.EnableEvents = True
End Sub

Let me know if it works for you.

Best regards,
Justyna

 

[MhmdHalawi]

I want them reversed, your code subtracted them but put the value in C2, I want it to be F1-C2, and the value put in F1

 

[MhmdHalawi]

I switched them and it worked, thank you so much <3<3

 

[JustynaMK]

Ahh right, sorry for that!
Cool, glad that it works take care.