Adding a count ticker to a pre-existing button

I have a button that clears all my data. A macro.
I am looking to have this button/macro also add a tally counter to another box, say (m2) every time it is pressed. I keep getting syntax errors.
Any thoughts?

Hi tek0011,

if you add:
Sheet1.Range("m2") = Sheet1.Range("m2") + 1
to your Macro as shown below, the macro will take the value from Cell M2, add 1 and save the "new" value back to Cell M2.
Additionally I have removed all the "select" commands, as they should be avoided.

The whole macro would need to look like this

Please Login or Register  to view this content.

Regards

Theo
__________________
Please consider:

Thanking those who helped you. Click the scales icon in the upper right corner of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.