macros to add numbers Closed

Question

Hello, 

I need to create a button and on every click of that button it should add 1 to it.
For Eg first click it should take data as 1 and second click it should add 1 to the previous 1 and cont with third click it should add 1 to the previous 2. Kindly help me how to create this.

Thanks,
Koushik

vcoolio · Answer

Hello Koushik,

I'm not sure if you have an existing macro to add this to or if you just want one to run on its own to increment the number in a cell but this may help:-

Sub AddIt()
Range("B4").Value = Range("B4").Value + 1
End Sub


Have a look at the following link to see it work:-

https://www.dropbox.com/s/fcizx2767c6drx9/Koushik.xlsm?dl=0

You may have to change the cell references to suit yourself.

I hope that this helps.

Cheerio,
vcoolio.

Macros to add numbers

1 response

Similar discussions

Subscribe To Our Newsletter!