ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Counter (https://www.excelbanter.com/excel-programming/368783-counter.html)

EMoe[_115_]

Counter
 

Hello Programmers!!!

Has anyone seen a code, or know of a code to make a counter in a
certain cell.

The object is to create a button with the macro attached to it.
Everytime you click the button, the number increases by one in the
assigned cell.

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=566474


Don

Counter
 
Sub test()
Range("a1") = Range("a1") + 1
End Sub


"EMoe" wrote in message
...

Hello Programmers!!!

Has anyone seen a code, or know of a code to make a counter in a
certain cell.

The object is to create a button with the macro attached to it.
Everytime you click the button, the number increases by one in the
assigned cell.

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile:
http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=566474




EMoe[_116_]

Counter
 

Thanks Don!

I feel so silly; that was so simple, and it works great.

Regards,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=566474



All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com