counter

[subfuntres]

I am trying to make cell count fro 1-100 automatically
Can anyone suggest vba code to do this thanks

 

[WaterGypsy]

I think we need a little more information ....

... what will make it change?

 

[subfuntres]

If it was cell a1 as soon as I enter a figure it should start the counter

 

[WaterGypsy]

Afraid I still don't know what you want.

If you enter a value in cell A1 do you want the counter to count from 1 to 100 immediately? This will simply happen very quickly and you will have 100 in the cell .. or do you want it to be incremented each time you enter something?

 

[subfuntres]

It would be great if it could count every second up to the value or even specify the time interval.