macro for button to increase count

Question

I need to increase the count each time i click the button, i need a macro for this.

Answer 1

You can drop the Value argument since it is the default and there are no other issues going on:

[A1] = [A1] + 1

---

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

Answer 2

hi

which one is the count?

Post the code that you tried.

regards

FSt1

Answer 3

this is what I want to do is when I click button the value in what ever cell on have highlighted increases in value. I used this last year and it worked great I only had to creat one button and just put my pointer on the cell then click the button and the number increased. so I tried the A1.value. = a1.value +1 and it only increases a1 and not the others.

Answer 4

I was using the button on forms, I tried command button but could not get it to work, I have my spread sheet as follows    

                          b       c        d         e       f

 10                       1

12                               1

14                                          1

when I click the button I would like the count to advance one

Answer 5

hi

try this.

Private Sub CommandButton1_Click()

[A1].Value = [A1].Value + 1

End Sub

i assumed that you are using a button from the control toolbox

make other adjustment as needed

regards

FSt1