nc wrote:

Hi

How can I update a variable by a value of one each time a
command button is clicked using macros?

Thanks.


---------------------------------

Even easier, rather than a "button" use a "spinner". It's available to
you on the same tool bar you'd use to create a "button". It provides a
both up and down buttons to increment or decrement a cell. In the
properties for the spinner you can define the cell to link it to. No
macro required.

Good luck...

Bill