How to: Create button that adds +1 to A1 field each time it's clicked.

**nigelbloomy** · 06-29-2015, 04:57 PM

Does this help?

Sub clickadd()
Range("A1") = Range("A1").Value + 1
End Sub

**100n3y** · 06-29-2015, 05:16 PM

Looks like it might, but you're giving me too much credit. So....would I plug this into a Form button or an Active X button? Once I've created the proper button....how do I plug it in and active it? My questions are too odd for Google to produce an answer for me. I have tried this first. Honest!

How to: Create button that adds +1 to A1 field each time it's clicked.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: How to: Create button that adds +1 to A1 field each time it's clicked.

Re: How to: Create button that adds +1 to A1 field each time it's clicked.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Create a button that adds current time into cell

Need to Advance time by 1 hour each time a button is clicked

[SOLVED] Record date last time button was clicked

Modifying a Macro Button to time stamp when the button was clicked.

Using a Form Button to add 1 to a cell each time it is clicked

Bookmarks

Bookmarks

Posting Permissions