Increment by 1

Posted by Roger Morrison on February 01, 2002 2:54 AM

The problem is, I have a value in O2 that needs to increase by 1 everytime I click a button I have created, It doesnt matter where the number starts from.

Cheers

Posted by Adnan Badar on February 01, 2002 3:35 AM

i can't understand ur problem correctly.
but if u want to increase every time to O2 then simply do this.

O2 = O2 +1

thats all.

Posted by Ian Mac on February 01, 2002 3:49 AM

Simply???

> Simply??

> Where, how, when??

> Is it??

Posted by Ian Mac on February 01, 2002 3:51 AM

First, Use the Controls Toolbox buttons (NOT the Forms one's)

Right click on the button you place on the screen and select View Code

Paste this in between the Sub and End Sub

Range("O2").Value = Range("O2").Value + 1

hope this helps

Ian Mac