Tracking Change on the Formula Bar

[amit700]

Hey Guys

I was having some troubles with my excel coding. Let me brief you on my excel workbook first

1. I have a cell in which a value is inputted by the user, cell A5
2. Cell A6 has the formula "=200+300"

The problem
1. If i enter a number in cell A5, this number should be put directly in the formula bar of cell A6

for example: on entering 10 in cell A5, formula bar for cell A6 should become ="200+300+10"

then if i just keep changing the number in cell A5, it should be reflected in the above manner in cell A6. So now inputting 20 in cell A5, cell A6 should show me = "200+300+10+20"

and so on.

The idea is that i want to track the changes i am making to that particular cell over a number of days.

Is there a way by using VBA codes to achieve this?

Thanks a lot for your help.

 

[Domski]

Maybe try this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target <> Range("A5") Then Exit Sub
Range("A6").Formula = Range("A6").Formula & "+" & Range("A5").Value
End Sub

Right click on the worksheet tab and select View Code and paste the above.

Dom

 

[amit700]

that was awesome dude...! thanks a lot ...