Using a macro to increase a value in a cell

Hello

I need some help. I am trying to set up a macro on a button so that when you click the button, it increases the value in a particular cell by 1.

E.g. If the value in the cell is 1 and I clicked the button, the value would increase to 2, if I clicked it again it would increase to 3 and so on.

Suggestions anyone?

Try this

Please Login or Register  to view this content.

MS

You can also put scroll bars and spinners directly onto your spreadsheet via the forms toolbar - might be more what you're looking for

MS

thanks for your help, the view code above doesn't work (compile error) but I will go with a scroll bar instead. It seems easier and I never thought of that. thanks

Hmmm. The code should work. Did you put it in a module (eg Module1)?

However you end up doing it, it's worth persevering with the code. I used to use spinners and such all the time, but if you get into VBA proper, it opens all sorts of possibilities you wouldn't have believed possible.