incrementing integers!

[dinosaur1993]

For instance if I clicked a button, it will generate a number starting from 60, How do I make it in a way that when I clicked the button again, it will increment by 1 using VBA?

Thanks in advance!
Dinosaur1993

[martindwilson]

try

Sub test()
If Range("a1").Value < 60 Then
Range("a1").Value = 60
Else
Range("a1").Value = Range("a1").Value + 1
End If

End Sub

[dinosaur1993]

In this one we had a restriction, how do we work it out if we dont have a restricted value? cheers

[martindwilson]

i have no idea what you mean

[dinosaur1993]

sorry for being vague.
Its like say for instance, initially, we know that we are counting to 60 yeah?

What if, we just keep on incrementing to infinity without knowing the end value?

[martindwilson]

thats not even the same question in your first post you say you want to start at 60 not finish at 60

[dinosaur1993]

oh wait, sorry my bad!!! I was thinking of another question