Cell A value change then value B keep on add

[Dean Zuki]

Hi Guys,

Is that possible if every time value A1 changed then B1 number value keep on add. Example: 00001,00002,00003.

Thank you

[Jonmo1]

You would need VBA code for that.

Can you clarify though, do you want to ADD or COUNT each time A1 changes.

If you start with 1 in A1, B1 would be 1
If you change A1 to say 5, should B1 be 2 or 6 ?
If then you change A1 to say 2, should b1 be 3 or 8 ?

[Dean Zuki]

Hi! I want to add every time A1 changes.

If the value change A1 to 5 the number will be 2.
The value will remain at B1.
The A1 value would be number & text.

thank you

[Jonmo1]

Right click on the Sheet's Tab, and click View Code
Paste the following code

Please Login or Register  to view this content.

[Jonmo1]

Wait, sounds like you want to COUNT, not ADD

change this line
Range("B1").Value = Range("B1").Value + Target.Value
to
Range("B1").Value = Range("B1").Value + 1

[Dean Zuki]

Hi Jonmo,

Sorry. Yes that is what I'm looking for. Reputation added.

Thank you very much for your help.

Rgds

[Jonmo1]

You're welcome